On 19 Oct 2011, at 8:26pm, Stephan Beal wrote: > On Wed, Oct 19, 2011 at 9:23 PM, Stephan Beal <sgb...@googlemail.com> wrote: > >> race conditions, unclean network connection errors, blah blah blah. That >> goes for all applications, not just databases. > > And not just for CIFS, but NFS and other networked filesystems as well. i'm > not personally aware of any (except maybe specialized clustered > environments) where file locking is "reliably well-behaved," but if there's > one out there someone else on this list certainly knows about it (and will > hopefully correct me).
There are bugs in the AFS implementation too. Slightly different ones in different versions. Think is, it's possible to do it right. It's just that doing it right means every operation takes two or three times as long as the slightly buggy implementations we have now. And people prefer fast-but-buggy. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users