I need to make a decision what SQL server to use the requirements are:
1. to have stored procedure 2. to be Open Source 3. To run on Linux and Windows
Some suggestions ?
Cheers Vasko
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.
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.
Or PostgreSQL. I admit to being no SQL guru, but when ever I look over the feature set comparison of both MySQL and PostgreSQL with my (limited) understanding of databases, I always wonder how on earth people write reliable ones using MySQL.
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
On 2004-01-27 12:42:46 +0000 Chris Green chris@areti.co.uk wrote:
Isn't there really only one answer - mysql.
Oooh, I hope your clothes are flameproof. Really, there seem to be four main candidates for databases, two of which I have used extensively: PostgreSQL and mysql (not sure mysql has stored procedures yet?); and two that I haven't: firebird and sapdb. I'm not that familiar with running them on Windows. Why not connect to a database server?
On Tuesday 27 January 2004 12:34, 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
Some suggestions ?
Cheers Vasko
InstantDB (http://instantdb.tripod.com/old-site/index.html) was a pure-Java RDBMS with stored procedures. I've been using it for about 4 years and not once has it ever corrupted data. Being Java of course it runs most anywhere, but only has interfaces to Java programs. Unfortunately, Lutris reneged on a promise to go Open Source so it's effectively disappeared. On a mailing list I came across the following:
"If you're looking for an open-source Java database solution, you may want to check out these:
McKoi is licensed under the GPL, while HSQL uses a BSD license."
-- GT
-
Chris Green -
Graham Trott -
Matt Parker -
MJ Ray -
Rob Kendrick -
Vasko Tomanov