From owner-freebsd-hackers@FreeBSD.ORG Sat May 12 11:52:14 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 8FFE916A402 for ; Sat, 12 May 2007 11:52:14 +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 14C8D13C45A for ; Sat, 12 May 2007 11:52:14 +0000 (UTC) (envelope-from stas@FreeBSD.org) Received: from [83.97.106.70] (helo=phonon.SpringDaemons.com ident=postfix) by com1.ht-systems.ru with esmtpa (Exim 4.62) (envelope-from ) id 1Hmq8y-0007PG-5D; Sat, 12 May 2007 15:52:12 +0400 Received: from localhost (localhost [127.0.0.1]) by phonon.SpringDaemons.com (Postfix) with SMTP id 3506611403; Sat, 12 May 2007 15:50:59 +0400 (MSD) Date: Sat, 12 May 2007 15:50:59 +0400 From: Stanislav Sedov To: Ivan Voras Message-Id: <20070512155059.92011d54.stas@FreeBSD.org> In-Reply-To: References: <200705102105.27271.blackdragon@highveldmail.co.za> 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=_Sat__12_May_2007_15_50_59_+0400_W_8kc=3K=KF8i/xv" X-Spam-Flag: SKIP 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: Sat, 12 May 2007 11:52:14 -0000 --Signature=_Sat__12_May_2007_15_50_59_+0400_W_8kc=3K=KF8i/xv Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit On Fri, 11 May 2007 02:10:05 +0200 Ivan Voras mentioned: > - I think it's time to give up on using BDB+directory tree full of text > files for storing the installed packages database, and I propose all of > 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 such > as reporting. 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 simple set of hashes will suffer or needs. I agree with Julian that we should have a backup of packaging database in plain text format, and utility to rebuild it. This way we can always restore the database if something goes wrong. Furhtermore, that should not make a great impact on performance, since we don't have to rebuild it every day. > > - A quick test confirms that the current bsdtar will happily ignore any > extra data at the end of a tgz/tbz archive, so package metadata can be > embedded there, thus conserving existing infrastructure and being fast > to parse. I suggest encoding this metadata in a sane and easy to parse > XML structure. > > I cannot currently actively participate in implementing proposed things, > but I can give advice on sqlite, database and xml schemas if anyone > wants to... > Why use XML for that? It's hard to parse and hard to read format, and I personally see no benefits of using it. If you're suggesting XML a simple bracket-structure format (like bind's config) will fit our needs much better (easier to parse and read and same benefits as XML). Also we might consider YAML, thought I like this idea much fewer. -- Stanislav Sedov ST4096-RIPE --Signature=_Sat__12_May_2007_15_50_59_+0400_W_8kc=3K=KF8i/xv Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (FreeBSD) iD8DBQFGRaojK/VZk+smlYERAn+nAJ0YUywP6wkswNr5GUMbBi5Qqk7nAgCfSxJE phiRoCqrRayKR4TgokUXbts= =l779 -----END PGP SIGNATURE----- --Signature=_Sat__12_May_2007_15_50_59_+0400_W_8kc=3K=KF8i/xv--