Hello, I'm thinking about using SQLite on a windows file share having multiple
clients reading and writing to the database. I think I understand the gist of
how this works via some really good docs on the SQLite site but from what I can
tell, it sounds like this isn't a canonical scenario for SQLite (which is fine,
I just am hoping to get some perspective). The FAQ mentions that file locking
of network files is very buggy and not dependable (in particular on Windows
file shares). Additionally I read the document on locking and concurrency (v3)
that in effect states the best defense is not use SQLite for files on a network
file system. I believe we will have moderate multi-client traffic and I was
hoping to gain some additional perspective from folks who have far more
experience using SQLite in this config. My impression is that its not really a
canonical scenario and I'm trying to get a handle on what I should expect or
even if I'm looking at the right database technology (assuming I am going to
have moderate concurrency to deal with). Many thanks in advance for your
thouhgts. Thanks,
Shawn
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
