From owner-freebsd-hackers@FreeBSD.ORG Sat May 12 21:26:21 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 81E3916A400 for ; Sat, 12 May 2007 21:26:21 +0000 (UTC) (envelope-from freebsd-hackers@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 0C83213C458 for ; Sat, 12 May 2007 21:26:20 +0000 (UTC) (envelope-from freebsd-hackers@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1Hmz6T-00067H-NB for freebsd-hackers@freebsd.org; Sat, 12 May 2007 23:26:13 +0200 Received: from 89-172-56-80.adsl.net.t-com.hr ([89.172.56.80]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 12 May 2007 23:26:13 +0200 Received: from ivoras by 89-172-56-80.adsl.net.t-com.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 12 May 2007 23:26:13 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-hackers@freebsd.org From: Ivan Voras Date: Sat, 12 May 2007 23:25:58 +0200 Lines: 47 Message-ID: References: <20070512004209.GA12218@lpthe.jussieu.fr> <17989.8202.624522.136573@bhuda.mired.org> <20070512090935.GA13929@lpthe.jussieu.fr> <20070512193302.GA24673@xor.obsecurity.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigF6442AB842370A2BED6C0E76" X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 89-172-56-80.adsl.net.t-com.hr User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) In-Reply-To: <20070512193302.GA24673@xor.obsecurity.org> X-Enigmail-Version: 0.94.3.0 Sender: news 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: Sat, 12 May 2007 21:26:21 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigF6442AB842370A2BED6C0E76 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Kris Kennaway wrote: > First figure out what specific problems need to be solved, then figure > out how to solve them, not the other way around. So far I have seen > little discussion of how SQLite is necessary and sufficient for fixing > fundamental issues. The argument in favour of SQL seems to boil down > to "It's SQL! You can do more complex queries...if you wanted to". I've posted some general ideas (resulting from my experience using the package / port system, not developing for it): 1. speed and simplicity of querying (single query vs traversing a tree of text files) 2. formal data constraints (UNIQUE, CHECK) 3. transaction safety (a consequence of which is the ability to run concurrent installs / updates) 4. easy interface for 3d party tools I admit again that I didn't develop anything with the package / ports subsystems, so there might be other, bigger problems not solvable by sqlite, but I believe the features above could at least solve performance problems. (I also agree there's no point in changing the ports infrastructure itself, just the package tracking database in base system). --------------enigF6442AB842370A2BED6C0E76 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.4 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGRjDmldnAQVacBcgRAoNjAJ49nGszEsRLWD5nXX9By0+a63Q1vACgyCgB hA/8hk2m1A0IbmRb2Kijtj4= =KArl -----END PGP SIGNATURE----- --------------enigF6442AB842370A2BED6C0E76--