We were far from a high concurrency use of sqlite, only 15 members, and using
only a single line insert. So i thought it should be ok.
I'll continue to use sqlite but as the only administrator of the DB :
I'll try to give the permissions rw-r--r-- to my file, and hope it'll works.
De : Kees Nuyt <k.n...@zonnet.nl>
À : sqlite-users@sqlite.org
Envoyé le : Dimanche 22 septembre 2013 10h25
Objet : Re: [sqlite] multiple connection to the same DB
On Sun, 22 Sep 2013 08:28:39 +0100 (BST), olivier Ménard
<men37...@yahoo.fr> 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 <slav...@bigfraud.org>
>À : olivier Ménard <men37...@yahoo.fr>; General Discussion of SQLite Database
><sqlite-users@sqlite.org>
>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 <men37...@yahoo.fr> 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
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
