Pick another RDBMS

views:

136

answers:

Pick another RDBMS

Other then Oracle, MySQL, and PostgreSQL, what is out there? Is there anything else used in a production environment? By production I mean it's used to support an active project or application and not an unstable system. I'm curious about other database systems (aside from NoSQL) that are applicable for use.

Looking at the feature set of those three, just about everything is covered. Why should I use something other then MySQL?

Bonus points if it works with Ibatis, some sort of Java connector is necessary though.

+5 A:

You didn't mention:

~~SQL Server~~
Teradata
Pervasive
Firebird
Informix
Sybase

OMG Ponies 2010-10-29 21:00:00

Drop SQL Server. Can you explain the other choices, how they differ with the ones I provided, and advantages / disadvantages? What keeps them out of the spotlight (at least in my opinion)?

Josh K 2010-10-29 21:01:26

@Josh K, don't ask a vague question and then criticize a response that perfectly answers you question.

mikerobi 2010-10-29 21:03:44

@Josh K: Pervasive is has had more of an embedded focus (used for AutoCAD in the past, along with various accounting packages). MySQL being free and the darling of OS is the main reason alternatives get noticed -- proof of that lies in the Express editions (Oracle, SQL Server, DB2) to combat it.

OMG Ponies 2010-10-29 21:05:09

+3 A:

SQLite
DB2
Informix
Derby
HSQLDB
Ingres

mikerobi 2010-10-29 21:01:17

Links please. ;)

Josh K 2010-10-29 21:01:52

@Josh K, I added a link to Derby, but I'm not going to bother with a bunch of products whose home pages will be the number 1 result if you google them.

mikerobi 2010-10-29 21:05:52

@mikerobi: I noticed, Derby was the only one I had trouble with.

Josh K 2010-10-29 21:07:06

Derby. Lightweight and perfect coupled with Java apps.

REW 2010-10-30 01:51:54

I'd prefer H2 over Derby. It seems to have a lot more momentum currently. If the aim is a Java embedded DB, the HSQLDB is worth looking at as well. 2.0 was recently released and has an impressive feature set.

a_horse_with_no_name 2010-10-30 18:02:27

+1 A:

Take a look at Oracle's Berkeley DB. In same memory space as app: key-value pair, transactions, isolation, very fast and performant. C, Java nd XML versions. Also, this might be useful: http://blogs.sun.com/natarajan/resource/Databases_for_Cloud.pdf

Joe 2010-10-29 21:09:00

+1 A:

Check this list at Wikipedia.

Frank Heikens 2010-10-30 17:59:08

If MySQL does the job for you, I don't think you need to change. But don't forget that MySQL is not free. If you are building a commercial application on top of MySQL, you have to buy a license.

Featurewise I think PostgreSQL is superior to MySQL (better query optimizer, windowing functions, common table expressions, check constraints, deferrable constraint just to name a few that MySQL is lacking) and it is really free.

MySQL might have a slight advantage if you need multi-master replication but there are solutions for PostgreSQL as well. And I guess we'll be seeing more now that streaming replication is built into Postgres (since 9.0)

To complete the list of databases there is also Greenplum (data warehouse, similar to Teradata)

a_horse_with_no_name 2010-10-30 18:06:43

ansaurus

tags:

views:

answers:

Pick another RDBMS

related questions