Hi
I'll try to give you more details
We were all on Ubuntu, each colleague on a different computer
with the sqlite command line tool i've created a db with
$ cd ....... sothat i'was located on a server directory shared with my
colleagues with the same permissions
$ sqlite3 birth.sqlite
>>> create table people(n,y);
>>> insert into people('olivier', 1969);
then from other computers
$ cd ...... to the same directory
$ sqlite3 birth.sqlite
>>> insert into people('simon', 1960);
finally from my computer :
>>> select * from people;
n y
------ ------
'simon' 1960
and olivier isn't in the DB.
Thank's for your help.
Olivier.
________________________________
De : Simon Slavin <[email protected]>
À : olivier Ménard <[email protected]>; General Discussion of SQLite Database
<[email protected]>
Envoyé le : Mardi 10 septembre 2013 21h43
Objet : Re: [sqlite] multiple connection to the same DB
On 10 Sep 2013, at 4:37pm, olivier Ménard <[email protected]> wrote:
> I've tried with my colleagues to write data to the same SQLite DB-file from
> differents accounts.
> When someone added a new line in the DB, sometimes older existing data were
> lost as if they had never existed and sometimes not.
>
> Why ?
>
> Multiple access are maybe allowed only for reading ?
What operating system are you using ?
What software or library calls are you using ? The SQLite shell tool ? The C
API ?
How are the computers you are using accessing the same file ? Are you using
access across a network ? If so, what network protocol are you using ?
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
