Date: Sat, 12 May 2007 16:25:06 +0200 From: Ivan Voras <ivoras@fer.hr> To: freebsd-hackers@freebsd.org Subject: Re: New FreeBSD package system (a.k.a. Daemon Package System (dps)) Message-ID: <f24io5$469$1@sea.gmane.org> In-Reply-To: <20070512155059.92011d54.stas@FreeBSD.org> References: <200705102105.27271.blackdragon@highveldmail.co.za> <f20c8u$htp$1@sea.gmane.org> <20070512155059.92011d54.stas@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --]
Stanislav Sedov wrote:
> On Fri, 11 May 2007 02:10:05 +0200
> Ivan Voras <ivoras@fer.hr> 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
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.
[-- Attachment #2 --]
-----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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?f24io5$469$1>