On 26 March 2011 12:15, Julien Laffaye <jlaffaye_at_freebsd.org> wrote: > On Fri, Mar 25, 2011 at 12:33 PM, Julien Laffaye <jlaffaye_at_freebsd.org> wrote: >> On Fri, Mar 25, 2011 at 11:52 AM, Ivan Voras <ivoras_at_freebsd.org> wrote: >>> At this time I'd just like to suggest you add the use of WAL journal >>> (http://www.sqlite.org/pragma.html#pragma_journal_mode) on database creation >>> so you get the benefits of multiple-readers-single-writer concurrency model. >> It sounds like a good idea. I'll add WAL support and if no problem >> arise from that we should keep it. > > Despite the fact that WAL allows cool things, one disadvantage is that > the process require write privileges on the database file even if it > is only reading. > Thus, pkg info and things like that would need to be run as root... You are right, I never tried it as read-only :( It looks like sqlite with WAL always needs write privileges at least to the directory in which the database is located. I think the workarounds are not worth the trouble.Received on Sat Mar 26 2011 - 18:35:44 UTC
This archive was generated by hypermail 2.4.0 : Wed May 19 2021 - 11:40:12 UTC