From owner-freebsd-hackers@FreeBSD.ORG Sun May 13 09:47:00 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 6844E16A407 for ; Sun, 13 May 2007 09:47:00 +0000 (UTC) (envelope-from stas@FreeBSD.org) Received: from com1.ht-systems.ru (com1.ht-systems.ru [83.97.104.204]) by mx1.freebsd.org (Postfix) with ESMTP id DFBC613C45A for ; Sun, 13 May 2007 09:46:59 +0000 (UTC) (envelope-from stas@FreeBSD.org) Received: from [85.21.245.235] (helo=phonon.SpringDaemons.com) by com1.ht-systems.ru with esmtpa (Exim 4.62) (envelope-from ) id 1HnAfJ-0001Du-QL; Sun, 13 May 2007 13:46:58 +0400 Received: from localhost (localhost [127.0.0.1]) by phonon.SpringDaemons.com (Postfix) with SMTP id 67E4111403; Sun, 13 May 2007 13:45:42 +0400 (MSD) Date: Sun, 13 May 2007 13:45:42 +0400 From: Stanislav Sedov To: Ivan Voras Message-Id: <20070513134542.7a1c7f71.stas@FreeBSD.org> In-Reply-To: References: <200705102105.27271.blackdragon@highveldmail.co.za> <20070512155059.92011d54.stas@FreeBSD.org> Organization: The FreeBSD Project X-Mailer: carrier-pigeon X-Voice: +7 916 849 20 23 X-XMPP: ssedov@jabber.ru X-ICQ: 208105021 X-Yahoo: stanislav_sedov X-PGP-Fingerprint: F21E D6CC 5626 9609 6CE2 A385 2BF5 5993 EB26 9581 X-University: MEPhI Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="PGP-SHA1"; boundary="Signature=_Sun__13_May_2007_13_45_42_+0400_iOxMvA=9WYJQGcL=" X-Spam-Flag: SKIP X-Spam-Yversion: Spamooborona 1.6.0 Cc: freebsd-hackers@freebsd.org 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: Sun, 13 May 2007 09:47:00 -0000 --Signature=_Sun__13_May_2007_13_45_42_+0400_iOxMvA=9WYJQGcL= Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit On Sat, 12 May 2007 16:25:06 +0200 Ivan Voras mentioned: > 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 time) > - 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. > I agree with everything, but, as was mentioned before, having such a complex product in base will involve a lot of pain. Furthermore, SQLite have a lot of features we don't need for our task. Probably, we should just sit, document features we need and implement required logic in e.g. bdb if not yet. -- Stanislav Sedov ST4096-RIPE --Signature=_Sun__13_May_2007_13_45_42_+0400_iOxMvA=9WYJQGcL= Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (FreeBSD) iD8DBQFGRt5GK/VZk+smlYERAjIeAJ9ORi1AYEopOMNZmAhZzXm5/0hTOQCfa4o0 8fWahpiNuK9I+cmGnLiysps= =8i69 -----END PGP SIGNATURE----- --Signature=_Sun__13_May_2007_13_45_42_+0400_iOxMvA=9WYJQGcL=--