On 14 Oct 2009, at 1:21am, priimak wrote: > http://www.sqlite.org/lockingv3.html
By the way, I just read some of that page and a bit of it, while possibly technically correct, may be putting some people off from using SQLite. "One should note that POSIX advisory locking is known to be buggy or even unimplemented on many NFS implementations (including recent versions of Mac OS X) and that there are reports of locking problems for network filesystems under Windows. Your best defense is to not use SQLite for files on a network filesystem." This is correct in that implementation of NFS file locking under OS X is buggy, as it is in many OSen. However, almost no users of OS X mount shared volumes using NFS. Both AFP and SMB offer so many other benefits (including decent security) that NFS is hardly used at all. And both AFP and SMB do locking properly (or at least any bugs do get fixed quickly because everyone complains about them). Perhaps this passage could be rephrased to warn explicitly about NFS rather than about the more general "files on a network filesystem". Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
