On Tue, 2004-01-27 at 12:42, Chris Green wrote:
On Tue, Jan 27, 2004 at 12:34:52PM -0000, Vasko Tomanov wrote:
I need to make a decision what SQL server to use the requirements are:
- to have stored procedure
- to be Open Source
- To run on Linux and Windows
Isn't there really only one answer - mysql. Unless there's some specific reason for not choosing mysql and/or a very big advantage for some other SQL server I can see no reason for choosing anything else.
MySQL fails the test since it doesn't have stored procedures (it also lacks transactional integrity amongst other things and is generally not a good RDBMS unless you are doing something REALLY simple). PostgreSQL is my "lightweight" RDBMS of choice and fulfils all the criteria above. In the open-source and "heavyweight" category, SAP (or MaxDB as it is now known) is now open source (and coincidentally comes under MySQL's administration now) - http://www.mysql.com/products/maxdb/
Matt