Hi, Although I read in a recent post by drh that it is not recommended to use sqlite in a local network I would like to ask if the following approach would work:
A database in the local network needs to be accessed by about 20 people. I suppose the max. number at the same time will be 4-5. Only one is able to write to the database at the same time. The one who wants to write to the database acquires an exclusive look with "PRAGMA locking_mode=EXCLUSIVE" if locking_mode is currently NORMAL. AFAIR all others should then still be able to read, but not to write. Is that correct and more or less save? Does anyone have experience with sqlite on a networkdrive? Thank you Jan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
