From owner-freebsd-current@FreeBSD.ORG  Sat Mar 26 11:16:00 2011
Return-Path: <owner-freebsd-current@FreeBSD.ORG>
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 3A37A106564A
	for <freebsd-current@freebsd.org>; Sat, 26 Mar 2011 11:16:00 +0000 (UTC)
	(envelope-from julien.laffaye@gmail.com)
Received: from mail-gw0-f54.google.com (mail-gw0-f54.google.com [74.125.83.54])
	by mx1.freebsd.org (Postfix) with ESMTP id D4B1B8FC13
	for <freebsd-current@freebsd.org>; Sat, 26 Mar 2011 11:15:59 +0000 (UTC)
Received: by gwb15 with SMTP id 15so856839gwb.13
	for <multiple recipients>; Sat, 26 Mar 2011 04:15:59 -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:date
	:x-google-sender-auth:message-id:subject:from:to:cc:content-type;
	bh=k6aOjbnA/Kc9YaslRMWUUnSrQ2gX0vNE0fPVND/9CLg=;
	b=KrsPE23bETH7t51tnvNYAvd3giFVjSwV+cy64fxRnNx65fHMhB0vvfxE8QrLfKzeVv
	oYEhDDAj+zAjc73jgBboHCwkTt+4Y/HkhdttxMK4HhCZ4TqZ7M8hUstDOE5qkXmhwuDm
	PWtHD1kwfvfK0G1CU/8PUKS5hvBFl9b9SxKSk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:in-reply-to:references:date
	:x-google-sender-auth:message-id:subject:from:to:cc:content-type;
	b=TyPEWOhTD90anBRg79xLMVrW+yIyqiBh79/DMLlh+3VYaJJvYcU8vuqWr7CEgqDce3
	93ltmQSEGQVx1uWUHBNMtJVKwbxDny2Mz8U9xWYgy1KZ/eokWcaq8sKj5i6mYzRmWmPv
	GuOVwgjoqpdsRiV8ZEJ03MNzWCESCh+OiJ/aQ=
MIME-Version: 1.0
Received: by 10.236.125.138 with SMTP id z10mr2755074yhh.185.1301138159115;
	Sat, 26 Mar 2011 04:15:59 -0700 (PDT)
Sender: julien.laffaye@gmail.com
Received: by 10.236.105.212 with HTTP; Sat, 26 Mar 2011 04:15:58 -0700 (PDT)
In-Reply-To: <AANLkTinV_3571iaa6c=5uCxYvHg-7+UOWQb=fGig3jVJ@mail.gmail.com>
References: <20110325101111.GA36840__48943.3474642739$1301049771$gmane$org@azathoth.lan>
	<imhvm9$hms$1@dough.gmane.org>
	<AANLkTinV_3571iaa6c=5uCxYvHg-7+UOWQb=fGig3jVJ@mail.gmail.com>
Date: Sat, 26 Mar 2011 11:15:58 +0000
X-Google-Sender-Auth: uiyr13Gv57vz0jsJqLKAwH916dQ
Message-ID: <AANLkTikH0VdONcAvZkuUCGzrCa3ha_KweXAdynpPU2aa@mail.gmail.com>
From: Julien Laffaye <jlaffaye@freebsd.org>
To: Ivan Voras <ivoras@freebsd.org>
Content-Type: text/plain; charset=ISO-8859-1
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
	<freebsd-current.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>, 
	<mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-current>,
	<mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 26 Mar 2011 11:16:00 -0000

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...

Regards,
Julien