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
