On Mon, Mar 26, 2001 at 13:18:46 -0500, Bob Hilliard wrote:
> Can some one give an objective comparison of the several
> relational database managers in debian (postgresql, mysql - are there
> any others?).
I've seen an ITP for InterBase (e.g. firebird.sourceforge.net), but no
packages yet.
As for MySQL v PostgreSQL, you may want to check out
http://openacs.org/philosophy/why-not-mysql.html
which lists a number of reasons why OpenACS (a RDBMS-heavy project) choose
not to support MySQL. Some of those reasons may no longer apply (e.g. recent
versions of MySQL support transactions), but much of it is still valid, in
particular if you require features to be time-tested.
Tim Perdue, "MySQL and PostgreSQL Compared",
http://www.phpbuilder.com/columns/tim20000705.php3
is also a very useful resource.
In my experience, PostgreSQL is a reliable RDBMS that supports many features
that make development of database-heavy applications easy, such as a large
sub-set of SQL (including e.g. subselects and views), transactions,
referential integrety (foreign keys), constraints, triggers (e.g. using the
Pl/PgSQL extension language). I'm using all of them in a telecom (voice)
billing application I'm responsible for at work.
HTH,
Ray
--
Cyberspace, a final frontier. These are the voyages of my messages,
on a lightspeed mission to explore strange new systems and to boldly go
where no data has gone before.
