oracle is best......

We use DB2 at work... whatever you do don't vote for DB2! I generally spend 10 minutes getting xyz done on MySQL (because it just works) and then spend the next 5 days moving xyz too DB2 because "DB2 is the platform we have always used and we are not about too change now, period".

Bobby

Yeah, but how much of that time is wasted because MySQL is extremely non-standard? It'd be a much more convincing argument if you were using an ANSI-compliant database as your point of comparison. And you might just discover that you're just thinking about things in ways that databases don't work.

But yeah, DB2 is pretty bad. Only database I've ever seen deadlock on a single row update with no other connections to the database...

I agree here!

Hmmm... I didn't knew that this is possible.

SQLite is awesome for quick-n-dirty databases. No setup! Imagine that!

Well, it shouldn't be possible to make a single row update in an otherwise quiet database deadlock unless you've messed up a bunch of triggers or something (which I hadn't done).

What was happening is that DB2 allows for Serializable and Repeatable Read by locking the 'next row' in all the indexes on the table. If you defined the right combination of indexes... BLAM! deadlock. It was 100% repeatable, too.

The solution was to twiddle some magic parameter that disabled RR and Serial consistency (which was fine in this case since we weren't using them).

Whats this Question? Mysql is the best and the most open one out there. Millions use it and why shouldn't we?
Linux Apache MySql perl/php/python (LAMP) Rocks!!

If it was 'the best', then there wouldn't be about 100 gotchas listed at http://sql-info.de/mysql/gotchas.html. It wouldn't think that Feb. 31st was a valid date. It would also come with 'features' such as being able to make a backup without shutting the database down. MySQL's stance is: get the feature in first; worry about it working correctly later. You want to trust your data to that? I certainly don't.

It's absolutely not the most open. The 'free' license is more restrictive than the GPL, which is pretty hard to do. SQLite is the most free: it's public domain. PostgreSQL is close behind; it's BSD license only means you have to maintain the copywrite/license notice and you can't sue UC Berkley.

Millions of people use Windows 98... should you? A lot of people using it doesn't mean it's good, by any stretch of the imagination.

Who would dispute the ever-popular MySQL?

Someone who can think for themselves? :P

Billions of flies eat feces, I still don't feel tempted, either ;}


Cheers,
Tink

I use MUMPS for programming databases, since that one isn't in the list I have to choose BerkeleyDB, it's lightning fast.

Then try Firebird embedded and come back ;-)

MySQL now have one of Database pioneers, Jim Starkey, who created Interbase (count Firebird here too) so their future looks bright, but only if they do what Jim says :-)
MySQL is NOT open, with their dual license... Firebird and PostgreSQL are!

That's an if that's unlikely to happen. They've had some clued folks over there for years, yet there's still all kinds of broken-ness.