From owner-freebsd-hackers@FreeBSD.ORG Mon May 14 16:48:42 2007 Return-Path: X-Original-To: freebsd-hackers@freebsd.org Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 8A24716A402 for ; Mon, 14 May 2007 16:48:42 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by mx1.freebsd.org (Postfix) with ESMTP id 1BF7313C448 for ; Mon, 14 May 2007 16:48:41 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: by ug-out-1314.google.com with SMTP id 71so1091969ugh for ; Mon, 14 May 2007 09:48:41 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=googlemail.com; s=beta; h=domainkey-signature:received:received:subject:from:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer; b=QKdG/irUg17KDX07DZsCnM/W3UYo1IrFXwnMzGZHTs0XKV59mBFW5M27bpFO9sTSqXDFy/hCuy+y1hKCwdbIE6wKSsUM20fVamZ8n80H3A2h3LI1koh8RHwEDJSqIeNOydtdW0Ef5072GjPw1mBBI7nVSFF1otZsXYjejg81kbU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=beta; h=received:subject:from:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer; b=IvOng8KT41f9SyzoZVN5DO4W+gQX3DIsmSg2D3mDC/C4Neszjn+aZGWd7Ieb1qcQswHTgv0WJE1owOCiGjdLIvKv17mtk2Mp+ELUV1W54dbiZMCkmeG6YjrOE6BcGxLJvYBiIGE271xYUuDuCRi3Q8HHJYiK+Xar2HjU0f6UIUE= Received: by 10.82.150.20 with SMTP id x20mr2085407bud.1179161321371; Mon, 14 May 2007 09:48:41 -0700 (PDT) Received: from ?IPv6:::ffff:127.0.0.1? ( [87.194.39.182]) by mx.google.com with ESMTP id c25sm15879148ika.2007.05.14.09.48.39; Mon, 14 May 2007 09:48:40 -0700 (PDT) From: Tom Evans To: 'Michel Talon' In-Reply-To: <20070514082512.GA25544@lpthe.jussieu.fr> References: <20070514082512.GA25544@lpthe.jussieu.fr> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-K/AQ0H1P/bytlceJUNlx" Date: Mon, 14 May 2007 17:48:38 +0100 Message-Id: <1179161318.1791.32.camel@zoot.mintel.co.uk> Mime-Version: 1.0 X-Mailer: Evolution 2.10.0 FreeBSD GNOME Team Port Cc: freebsd-hackers@freebsd.org, Thomas Sparrevohn Subject: Re: DPS Initial Ideas X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 May 2007 16:48:42 -0000 --=-K/AQ0H1P/bytlceJUNlx Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Mon, 2007-05-14 at 10:25 +0200, 'Michel Talon' wrote: > On Mon, May 14, 2007 at 12:33:23AM +0100, Thomas Sparrevohn wrote: > >=20 > > converted INDEX > > into postgresSQL because I was playing around with making a message que= ue > > based approach - > > and it becomes BIG - The only table structure difference from the curre= nt > > format was that I=20 > > was able to track "who is depending on" a port - which I am pretty sure > > could be handled in the > > current framework - e.g. we could add a file having the depending port = names > > or so >=20 >=20 > niobe% cp /usr/ports/INDEX-6 . > niobe% sqlite3 index.db > sqlite> CREATE TABLE index6 ( > pkgname varchar(1), > path varchar(1), > prefix varchar(1), > comment varchar(1), > descr varchar(1), > maintainer varchar(1), > categories varchar(1), > build_deps varchar(1), > run_deps varchar(1), > website varchar(1), > extract_deps varchar(1), > patch_deps varchar(1), > fetch_deps varchar(1)); > sqlite> .import INDEX-6 index6 > ... completes in less than 2 seconds > sqlite> select * from index6 where path =3D "/usr/ports/accessibility/atk= "; > atk-1.12.4|/usr/ports/accessibility/atk|/usr/local|A GNOME accessibility > toolkit > (ATK)|/usr/ports/accessibility/atk/pkg-descr|gnome@FreeBSD.org|accessibil= ity > devel|gettext-0.14.5_2 glib-2.12.9 libiconv-1.9.2_2 libtool-1.5.22_3 > perl-5.8.8 pkg-config-0.21|gettext-0.14.5_2 glib-2.12.9 libiconv-1.9.2_2 > perl-5.8.8 > pkg-config-0.21|http://developer.gnome.org/projects/gap/||libtool-1.5.22_= 3| >=20 > niobe% ls -lh INDEX-6 index.db=20 > -rw-r--r-- 1 michel lpthe 9,5M 14 mai 10:00 INDEX-6 > -rw-r--r-- 1 michel lpthe 12M 14 mai 10:12 index.db >=20 > Where is this huge increase in size? > Admittedly, i have not created indexes, etc. ^^^^^^^^^^^^^^^^^^^^^^^^^^ > Compare this to the portsdb created by portupgrade from the same INDEX-6 >=20 > niobe% ls -lh /usr/ports/INDEX-6.db > -rw-r--r-- 1 root wheel 21M 16 f=C3=A9v 13:36 /usr/ports/INDEX-6.db >=20 > Surprise, surprise, the BerkeleyDB suddenly appears less glorious. Your index has no indices, and you wonder why it is smaller? --=-K/AQ0H1P/bytlceJUNlx Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (FreeBSD) iD8DBQBGSJLmlcRvFfyds/cRAgUZAJkBLHMhINAoc19f9X6dEha8gq21mgCeImNY 7dGUv7+V53R4tSe0mhRdoOI= =BjY1 -----END PGP SIGNATURE----- --=-K/AQ0H1P/bytlceJUNlx--