On 2016/06/13 2:20 PM, Luc DAVID wrote:
Hello,
I'm planning to install an application using sqlite on a windows 2003
server.
The application exe + sqlite dll + database will be installed in the same
server directory.
The application will be used by ± 10 users via RDP TSE clients.
I need to take care of possible database locks during writing operations
(not much) (10% writing, 90% reading).
I am wondering if WAL mode is the way to go and if it is safe to use
sqlite
in WAL mode on this kind of configuration.
Hi Luc,
There is no safe way to do what you need. Networked file systems do not
play nice with file-locking. SQLite is suitable for localized storage,
not Networked-multi-user-access systems. You need a client-server
architecture for that.
Unless I am mistaken and all teh 10 users access the DB from the same
computer, or you have an interface application that accesses the DB and
then serves the data to the clients, there is no safe way to access an
SQLite DB file via a network from many clients - WAL or no WAL.
For more specific information you may read:
https://www.sqlite.org/howtocorrupt.html
https://www.sqlite.org/whentouse.html
Cheers,
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users