On 26 March 2011 12:15, Julien Laffaye <jlaff...@freebsd.org> wrote: > On Fri, Mar 25, 2011 at 12:33 PM, Julien Laffaye <jlaff...@freebsd.org> wrote: >> On Fri, Mar 25, 2011 at 11:52 AM, Ivan Voras <ivo...@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. _______________________________________________ freebsd-current@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-current To unsubscribe, send any mail to "freebsd-current-unsubscr...@freebsd.org"
