On 12 Jul 2018, at 19:11, Richard Hipp wrote:

> When network filesystems do not follow the usual semantics of a
> filesystem, it can cause problems.
>
> That said, Firefox and Chrome have for many years stored lots of stuff
> in SQLite database files in the users home directory, which is often a
> network share, and they have not reported any problems.

Hi, ok, that’s good news. So it’s definitely possible to get working.

> On the other hand, they (or at least Firefox, I not sure about Chrome) run 
> with
> PRAGMA locking_mode=EXCLUSIVE [1] which tends to bypass most of the
> network filesystem bugs, at the expense of restricting database access
> to a single process at a time.

Ok, we can try that.

> Is your system able to live with that restriction and use PRAGMA
> locking_mode=EXCLUSIVE?

Yes, that shouldn’t be a problem. Thanks.

-- 

Robert M. Münch, CEO
M: +41 79 65 11 49 6

Saphirion AG
smarter | better | faster

http://www.saphirion.com
http://www.nlpp.ch

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to