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:
1. to have stored procedure 2. to be Open Source 3. 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. -- Chris Green (chris@areti.co.uk)
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:
1. to have stored procedure 2. to be Open Source 3. 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. -- Rob Kendrick, Pepperfish Ltd. +44 (0)845 226 4146 www.pepperfish.net PGP signed or encrypted mail welcome Key ID: 3651D17A
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:
1. to have stored procedure 2. to be Open Source 3. 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 -- http://www.mpcontracting.co.uk Experts in Java development and website design
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? -- MJR/slef My Opinion Only and possibly not of any group I know. Please http://remember.to/edit_messages on lists to be sure I read http://mjr.towers.org.uk/ gopher://g.towers.org.uk/ slef@jabber.at Creative copyleft computing services via http://www.ttllp.co.uk/
On Tuesday 27 January 2004 12:34, Vasko Tomanov wrote:
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
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: http://www.mckoi.com http://hsqldb.sourceforge.net McKoi is licensed under the GPL, while HSQL uses a BSD license." -- GT
participants (6)
-
Chris Green -
Graham Trott -
Matt Parker -
MJ Ray -
Rob Kendrick -
Vasko Tomanov