On Sun, 22 Sep 2013 08:28:39 +0100 (BST), olivier Ménard
<[email protected]> wrote:
>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.
Many network file systems do not behave well with SQLite:
http://sqlite.org/lockingv3.html#how_to_corrupt
That is especially true when the network file server and/or network file
client are heavily optimized for speed.
You can try to recompile SQLite to use dot-file locking:
http://www.sqlite.org/compile.html#enable_locking_style
If you need a database server, SQLite is not the perfect choice. In
those use cases, a database server like PostgresQL or MySQL or MariaDB
and its respective client program is more appropriate:
http://sqlite.org/whentouse.html
More info:
http://www.sqlite.org/search?q=locking
>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
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
