Date: Sat, 26 Mar 2011 20:35:03 +0100 From: Ivan Voras <ivoras@freebsd.org> To: Julien Laffaye <jlaffaye@freebsd.org> Cc: freebsd-current@freebsd.org Subject: Re: [ECFT] pkgng 0.1-alpha1: a replacement for pkg_install Message-ID: <BANLkTinQC6yc2fPNpE8BnrYHtmMsnCaWyg@mail.gmail.com> In-Reply-To: <AANLkTikH0VdONcAvZkuUCGzrCa3ha_KweXAdynpPU2aa@mail.gmail.com> References: <20110325101111.GA36840__48943.3474642739$1301049771$gmane$org@azathoth.lan> <imhvm9$hms$1@dough.gmane.org> <AANLkTinV_3571iaa6c=5uCxYvHg-7%2BUOWQb=fGig3jVJ@mail.gmail.com> <AANLkTikH0VdONcAvZkuUCGzrCa3ha_KweXAdynpPU2aa@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 26 March 2011 12:15, Julien Laffaye <jlaffaye@freebsd.org> wrote: > On Fri, Mar 25, 2011 at 12:33 PM, Julien Laffaye <jlaffaye@freebsd.org> wrote: >> On Fri, Mar 25, 2011 at 11:52 AM, Ivan Voras <ivoras@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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BANLkTinQC6yc2fPNpE8BnrYHtmMsnCaWyg>