This argument is out of date. MySQL currently supports
transactions, foreign
keys, and outer joins. (4.1 will support subselects)
As for fault tolerance, MySQL has built in support for replication.
A couple years ago I converted a project from MySQL to PostgreSQL
because
of MySQL's lack of features. I am now in the process of converting
back to
MySQL because of the performance improvements and replication.
>
> Be a little bit careful about benchmarks. Whether postgresql or
> mysql is
> faster depends on what you're doing. If all you want to do is the
> occasional
> insert and lots and lots of simple selects, mysql (or even grep)
> will beat
> postgres. If you want to do subselects, transactions, foreign
> keys, outer
> joins, fault tolerence or anything else that makes a database a
> database,
> mysql just can't do it.
>
> See if MySQL and PostgreSQL satisfy your business requirements and then
> decide which one you want.