On Thu, 2005-07-28 at 11:28 +0200, djm wrote: > Hello, > > The documentation suggests that its unsafe to use SQLite when the > database file is on a windows network server and various other > machines may want to simultaneously access it. If however none of > these machines change the data in the databse (all accesses are just > queries) is it then completely safe? > > Presumably only querying the database (and not inserting/altering etc) > translates internally in sqlite to opening the database in read_only > mode, which is presumably safe to do in several clients concurrently? > If so from what version of windows/sqlite can I be confident?
Understanding what underlying operations aren't safe, is helpful. If there's never any writers, why bother keeping it on the network? Have your program "check the network server" for a newer version of the file and copy it down if necessary. This will reduce network traffic because you won't be checking for locks every query...
