[Dbix-class] any factual comparisons of Oracle, PostgreSQL, MySQL ?

[Kaare Rasmussen]

Late to the party, I'd like to offer some general advice.

You have to think about what you expect from the DBMS. Will you have all the 
logic in the application, or will you offload work to the database.

If you like to use the DBMS as a data store, MySQL is a very good choice. But 
perhaps some of the "new" nosql bases (CouchDB, MongoDB, Redis, etc) could do 
the same job better or faster.

If you like the DBMS to do some work for you, PostgreSQL is the best Open 
Source choice. Paying for it could bring you Oracle, DB2, SQL Server. With 
PostgreSQL you could for example use Perl (or a lot of other languages) for 
functions.

My personal money is on PostgreSQL. It's gaining features fast (9.1 coming out 
RSN), and performance gets better for every release. Your choice may be 
different, though.

> Hi there,
> 
> 
> 
> This is not a DBIC question, but since there are lots of database
> administrators from various platforms on this list, I hope to find some
> help.
> 
> 
> 
> I have an important database migration project, aiming at replacing an
> old DBMS by something more up to date, for mission-critical
> applications. We are still at a very early phase of the selection
> process, but some of the requirements will be : high-availability ,
> support for multi-values, fulltext search, data domains, inheritance,
> CHECK constraints and triggers. The short list of candidate DBMS  is
> likely to be Oracle, PostgreSQL and MySQL.
> 
> 
> 
> Question : do you know of some good sources of factual information that
> could help us in the comparison process ?
> 
> 
> 
> Thanks in advance, Laurent Dami.
> 

-- 
Med venlig hilsen
Kaare Rasmussen, Jasonic

Jasonic                 Telefon: +45 3816 2582
Nordre Fasanvej 12
2000 Frederiksberg      Email: kaare at jasonic.dk