I came across the following document posted to the mysql mailing list today. It’s a great feature comparison between MySQL, PostgreSQL, Firebird, MaxDB and Ingres.
You can download the paper here.
Whilst this may only list supported features as of MySQL 4.1.10 – once you know the new features available in MySQL 5.0, it’s easy to see there really isn’t very much holding MySQL back when compared to other open source offerings.
This is certainly one of those papers that should be handed to all of those PostgreSQL “fanboys” that constantly spout about MySQL *not* supporting ACID transactions, transaction isolation, row level locking and foreign keys etc. It even shows that MySQL supports *more* transaction isolation levels than PostgreSQL.
A very interesting read for anybody currently trying to decide which open source offering to go with!
Mark,
Thanks for posting this, and thanks for the encouraging comments! We do all we can to produce the best and fastest database in the world.
I’m speachless …. really interesting stuff. (personally interested in Firebird informations)