Linux DB's - seeking opinions

Hi All - Am looking for informed opinions regarding data base managers on Linux.
Would like pro's/con's for: postgres, mysql, msql, and any others you have had hands on experience with.
Especially would like to hear from those who have used two or more of the above.
Regards, Guy

I have used postgrSQL, and thought it was fine (no GUI if that sort of thing bothers you).
It has actually been about 18months since then, so perhaps things have changed, but as I said, it was fine then. (It was on Debian).
People who use mySql tell me things about foreign keys and weak typing that make me very, very worried, but I cant say that I have ever actually used it.

MySQL is probably the most popular open-source DBMS and it's used to drive a lot of websites. Historically, however it hasn't had industrial-strength things like transaction management. That's a problem they've been devoting much effort towards lately, however, so it may soon cease to be an issue.
PostgreSQL has better transaction management and has been positioned as a "bulletproof" system. It often comes in second in benchmarks, but they've been putting considerable stress on reliability concerns and international language support.
You can occasionally find comparisons in magazines and on the web, though I'd check the age of the review before making serious judgments, since neither is sitting still.

Here's a comparison of mySQL and PostGreSQL I found useful. It's a web-centric perspective, of course.
------------------
Michael Ernest, co-author of: The Complete Java 2 Certification Study Guide

A friend of mine raves about sapDB (from http://www.sapdb.org/) -- has anybosy had expecience of it, and if so, how does it compare??

All - thanks for the replies.
Michael - in the interim I had stumbled across the same article. Indeed it was useful.
Of course Postgres and MySQL came with my OS. I've fooled a little with both. This is not an urgent requirement.
I also have a 'trial' copy of DB2 on order.
Anyone ever work with that on Linux??
Much like DB2 on mainframes I suspect (am quite familiar with that stuff). I'm somwhat attracted to that because of IBM's -very large- commitment to supporting Java.
Regards, Guy

[This message has been edited by Guy Allard (edited December 18, 2001).]

For me, its a no-brainer... use Interbase (or Firebird).
Its an industry-strength DBMS with transactions, stored procedures, triggers, events, etc. Everything you need for your data with very little maintenance required. I use it for my web-site, my telephony/realtime apps, and standard Windows client/server stuff.
I've tried mySQL. It's good... a little slow if your database has lots of writes (good for reads though). But I changed to Interbase and will never look back. Having stored procedures makes a world of difference.
Best of all, its free and runs on Linux/Solaris/Windows.
Eric.

Theres always the Oracle option out there now. Free for non-commercial use.