From owner-freebsd-hackers@FreeBSD.ORG Sat May 12 14:25:49 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 269A016A400 for ; Sat, 12 May 2007 14:25:49 +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 A687813C447 for ; Sat, 12 May 2007 14:25:48 +0000 (UTC) (envelope-from freebsd-hackers@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HmsXJ-0000SF-Qd for freebsd-hackers@freebsd.org; Sat, 12 May 2007 16:25:29 +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 16:25:29 +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 16:25:29 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-hackers@freebsd.org From: Ivan Voras Date: Sat, 12 May 2007 16:25:06 +0200 Lines: 60 Message-ID: References: <200705102105.27271.blackdragon@highveldmail.co.za> <20070512155059.92011d54.stas@FreeBSD.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigBB992BE5955A3EEDFBEF67F3" 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: <20070512155059.92011d54.stas@FreeBSD.org> X-Enigmail-Version: 0.94.3.0 Sender: news Subject: Re: New FreeBSD package system (a.k.a. Daemon Package System (dps)) 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 14:25:49 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigBB992BE5955A3EEDFBEF67F3 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Stanislav Sedov wrote: > On Fri, 11 May 2007 02:10:05 +0200 > Ivan Voras mentioned: >=20 >> - I think it's time to give up on using BDB+directory tree full of tex= t >> files for storing the installed packages database, and I propose all o= f >> this be replaced by a single SQLite database. SQLite is public domain >> (can be slurped into base system), embeddable, stores all data in a >> single file, lightweight, fast, and can be used to do fancy things suc= h >> as reporting. >=20 > What is the reason to use SQL-based database? You'll perform direct > queries to database? The packaging system is for ordinal users, not sql= > geeks, so they should not have to use sql for managing packages. So a It's not SQL I'm interested in, it's the "additional" features: - performance - transaction safety ("commit all changes or none") - constraints (like "unique" keys - sqlite unfortunately doesn't support foreign keys) - concurrent access (allowing to run multiple portupgrades at the same ti= me) - easy interface to C programs If a BDB variety or some other storage layer can achieve these things, I'll likely support them. I know "Sleepycat" BDB implementations boast "transaction processing", but can they offer this across multiple stores / databases at the same time (i.e. like one transaction includes updates to multiple tables)? Efficient (performance-wise) storage would probably need to use more than one store, at least to index data by different keys. --------------enigBB992BE5955A3EEDFBEF67F3 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 iD8DBQFGRc5CldnAQVacBcgRAqeoAKCbX8drKd6UJVe9do1cWgInnWLLxQCeP8pd 5jzs0S7eU4uzpj/Pb4bKoNY= =SOb4 -----END PGP SIGNATURE----- --------------enigBB992BE5955A3EEDFBEF67F3--