Thanks Hick, points noted.

James

-----Original Message-----
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Hick Gunter
Sent: 11 January 2018 09:23
To: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] [EXTERNAL] SQLite Application Server Concurrency

Accessing SQLite files via network filesystems is high on the list of "how to 
corrupt SQLite databases", see section 2.1 in 
http://sqlite.org/howtocorrupt.html

WAL mode requires shared memory. How are you going to do that with processes 
running on different PCs? See sections 4 and 6 of http://sqlite.org/wal.html.



-----Urspr√ľngliche Nachricht-----
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von James Colehan
Gesendet: Donnerstag, 11. Jänner 2018 10:07
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] [sqlite] SQLite Application Server Concurrency

Hi,

I am looking for some advice on using SQLite for my given situation.

My system involves a windows network. On PC 'X', I have an SQLite database with 
a process that handles amendment's to the database ie INSERTS, DELETES and 
UPDATES. Also, on PC 'X' I have some other processes running that are 
requesting data (SELECT) form the database. I have the Journal Mode set to WAL. 
This all appears to work fine.

My concern is that I have a requirement to query the database on PC 'X' from 
other PC's. Basically, performing (SELECT) statements from stations 'Y' and 
'Z'. This creates a client/server situation that I appreciate SQLite is not 
appropriate choice of database for. I hope doing the (SELECT) only from the 
client will be a workable solution.

At the moment I have not encountered any problems. However, my concern is that 
this maybe just luck and there is a potential of locking issues or database 
corruption.

Any thoughts would be appreciated.

Regards,

James


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___________________________________________
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to