Thanks Hick, points noted.


-----Original Message-----
From: sqlite-users [] On 
Behalf Of Hick Gunter
Sent: 11 January 2018 09:23
To: 'SQLite mailing list' <>
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

WAL mode requires shared memory. How are you going to do that with processes 
running on different PCs? See sections 4 and 6 of

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


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 

Any thoughts would be appreciated.



sqlite-users mailing list

 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 mailing list

Reply via email to