Wout Mertens wrote: > I know that multi-writer sqlite and NFS don't play well with each other. > > However, I wonder if some constraints could be added that would make this > situation safe.
NFS locking implementations tend to be bad. However, there are other file operations that are properly synchronized, e.g., it is not possible for two NFS clients to create a directory with the same name. So as long as all programs that access the database cooperate, they can switch to a different locking implementation, such as the unix-dotfile VFS: https://www.sqlite.org/vfs.html#standard_unix_vfses Note: this makes all accesses, even reads, take an exclusive lock. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users