[ECFT] pkgng 0.1-alpha1: a replacement for pkg_install

[Ivan Voras]

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.