From owner-freebsd-hackers@FreeBSD.ORG Mon May 14 08:25:15 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 779D616A406 for ; Mon, 14 May 2007 08:25:15 +0000 (UTC) (envelope-from talon@lpthe.jussieu.fr) Received: from shiva.jussieu.fr (shiva.jussieu.fr [134.157.0.129]) by mx1.freebsd.org (Postfix) with ESMTP id EC87913C505 for ; Mon, 14 May 2007 08:25:14 +0000 (UTC) (envelope-from talon@lpthe.jussieu.fr) Received: from parthe.lpthe.jussieu.fr (parthe.lpthe.jussieu.fr [134.157.10.1]) by shiva.jussieu.fr (8.13.8/jtpda-5.4) with ESMTP id l4E8PC2j054747 ; Mon, 14 May 2007 10:25:12 +0200 (CEST) X-Ids: 164 Received: by parthe.lpthe.jussieu.fr (Postfix, from userid 10096) id 7EBF2BF6A2; Mon, 14 May 2007 10:25:11 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.1.8 (2007-02-13) on parthe.lpthe.jussieu.fr X-Spam-Level: X-Spam-Status: No, score=-2.2 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=3.1.8 Received: from asmodee.lpthe.jussieu.fr (asmodee.lpthe.jussieu.fr [134.157.10.34]) by parthe.lpthe.jussieu.fr (Postfix) with ESMTP id A69ECBF4FE; Mon, 14 May 2007 10:25:10 +0200 (CEST) Received: by asmodee.lpthe.jussieu.fr (Postfix, from userid 2005) id 62A3B42C6; Mon, 14 May 2007 10:25:12 +0200 (CEST) Date: Mon, 14 May 2007 10:25:12 +0200 From: "'Michel Talon'" To: Thomas Sparrevohn Message-ID: <20070514082512.GA25544@lpthe.jussieu.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.4.2.2i X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-3.0 (shiva.jussieu.fr [134.157.0.164]); Mon, 14 May 2007 10:25:12 +0200 (CEST) X-Virus-Scanned: ClamAV 0.88.7/3242/Mon May 14 06:57:51 2007 on shiva.jussieu.fr X-Virus-Status: Clean X-Miltered: at shiva.jussieu.fr with ID 46481CE8.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Mailman-Approved-At: Mon, 14 May 2007 11:29:34 +0000 Cc: freebsd-hackers@freebsd.org 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 08:25:15 -0000 On Mon, May 14, 2007 at 12:33:23AM +0100, Thomas Sparrevohn wrote: > > converted INDEX > into postgresSQL because I was playing around with making a message queue > based approach - > and it becomes BIG - The only table structure difference from the current > format was that I > 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 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 = "/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|accessibility 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| niobe% ls -lh INDEX-6 index.db -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 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 niobe% ls -lh /usr/ports/INDEX-6.db -rw-r--r-- 1 root wheel 21M 16 fév 13:36 /usr/ports/INDEX-6.db Surprise, surprise, the BerkeleyDB suddenly appears less glorious. -- Michel TALON