Re: [sqlite] Database locking without locking database file

2013-08-14 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/08/13 06:06, Ralf Ramsauer wrote: > Neither cifs. I worked on a CIFS server (visionfs)[1]. They are a convoluted complicated mess. During the OLE2 era, Microsoft's apps abused locking as a means of inter-process communication. It got very com

Re: [sqlite] Database locking without locking database file

2013-08-14 Thread Ralf Ramsauer
On 14.08.2013 18:36, Stephan Beal wrote: > On Wed, Aug 14, 2013 at 3:06 PM, Ralf Ramsauer < > ralf+sql...@ramses-pyramidenbau.de> wrote: > >> Why is it proposed not to use NFS? Why is it so risky? I can hardly >> believe that NFS locking is that broken... >> > Few of us can believe it, but many of

Re: [sqlite] Database locking without locking database file

2013-08-14 Thread Simon Slavin
On 14 Aug 2013, at 5:36pm, Stephan Beal wrote: > On Wed, Aug 14, 2013 at 3:06 PM, Ralf Ramsauer < > ralf+sql...@ramses-pyramidenbau.de> wrote: > >> Why is it proposed not to use NFS? Why is it so risky? I can hardly >> believe that NFS locking is that broken... > > Few of us can believe it, bu

Re: [sqlite] Database locking without locking database file

2013-08-14 Thread Stephan Beal
On Wed, Aug 14, 2013 at 3:06 PM, Ralf Ramsauer < ralf+sql...@ramses-pyramidenbau.de> wrote: > Why is it proposed not to use NFS? Why is it so risky? I can hardly > believe that NFS locking is that broken... > Few of us can believe it, but many of us have had horrible experiences (regardless of sq

Re: [sqlite] Database locking without locking database file

2013-08-14 Thread Ralf Ramsauer
Hi, thanks a lot for your answer. On 14.08.2013 13:52, Richard Hipp wrote >> Now my Question: >> According to [4], it seems that NFS also has problems with sharing >> locks. So why does Sqlite make use of file locks instead of writing >> those locks (including a timestamp for expiration) inside t

Re: [sqlite] Database locking without locking database file

2013-08-14 Thread Richard Hipp
On Tue, Aug 13, 2013 at 11:35 AM, Ralf Ramsauer wrote: > Now my Question: > According to [4], it seems that NFS also has problems with sharing > locks. So why does Sqlite make use of file locks instead of writing > those locks (including a timestamp for expiration) inside the database > file or b

[sqlite] Database locking without locking database file

2013-08-14 Thread Ralf Ramsauer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, the FAQ of qemu describes Sqlite to be threadsafe [1]. The "threadsafeness" can e.g. be chosen at compiletime [2]. If several Sqlite instances try to access the same database file on a system, the database file gets locked via simple file locks