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: [email protected] _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
