From owner-freebsd-current@FreeBSD.ORG Sat Mar 26 19:35:44 2011 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 5F231106564A for ; Sat, 26 Mar 2011 19:35:44 +0000 (UTC) (envelope-from ivoras@gmail.com) Received: from mail-qy0-f175.google.com (mail-qy0-f175.google.com [209.85.216.175]) by mx1.freebsd.org (Postfix) with ESMTP id 0195D8FC0C for ; Sat, 26 Mar 2011 19:35:43 +0000 (UTC) Received: by qyk35 with SMTP id 35so354140qyk.13 for ; Sat, 26 Mar 2011 12:35:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:in-reply-to:references:from :date:x-google-sender-auth:message-id:subject:to:cc:content-type; bh=s7SmE5a2VtrScwEvQ1/7Wde2S7KxzEEzo4dtcD/pd2k=; b=H0jIeXAIC7wJBVH7B/dAchArwBl0xW6AhB8CzL1p5+ofhS4/gI8LJQMOnl56/5y3lz vpsDwqqDy8aloV+ntA6vAKiU/rjU+hjfboVYuKcp9XMQYvmVisapfnkTPNbnC6IUe7oP Gk4KT+JeSBb/MATheP2ArpCNBY0RgvXsbB6d0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type; b=ZHmkPr7ENHTeebVaLzauSRcxVQuJAxNsyAEQA9MQFaE/8I+S82lBqg7zMeP+6fpHJQ OeydJhp4LY9CxLfCE7OJY9co9YlwWbzLlou178Lx+lopWoTEEUJgq+UddDunPjQm6XJ7 eVVNsyx0OfNXjI++hoMXaqzhSHt+9Fus/CoP8= Received: by 10.229.107.15 with SMTP id z15mr1903704qco.99.1301168143097; Sat, 26 Mar 2011 12:35:43 -0700 (PDT) MIME-Version: 1.0 Sender: ivoras@gmail.com Received: by 10.229.78.193 with HTTP; Sat, 26 Mar 2011 12:35:03 -0700 (PDT) In-Reply-To: References: <20110325101111.GA36840__48943.3474642739$1301049771$gmane$org@azathoth.lan> From: Ivan Voras Date: Sat, 26 Mar 2011 20:35:03 +0100 X-Google-Sender-Auth: XdqGVTMXSn5gX68l-RJIvzbGN-c Message-ID: To: Julien Laffaye Content-Type: text/plain; charset=UTF-8 Cc: freebsd-current@freebsd.org Subject: Re: [ECFT] pkgng 0.1-alpha1: a replacement for pkg_install X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 26 Mar 2011 19:35:44 -0000 On 26 March 2011 12:15, Julien Laffaye wrote: > On Fri, Mar 25, 2011 at 12:33 PM, Julien Laffaye wrote: >> On Fri, Mar 25, 2011 at 11:52 AM, Ivan Voras 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.