mySQL or PostgreSQL?

\_ SMTP quoth David Mandala on 2/13/2003 09:18 as having spake thusly:
\_
\_ The answer is it depends. On what, features. MySQL is lightweight fast
\_ and fairly simple. PostgreSQL is more feature rich, supports true
\_ transactions and is just about as fast as MySQL.
\_
\_ If you are just attempting to learn MySQL is fine, if you are doing
\_ anything where the data matters PostgreSQL is the way to go.

The link previously given was a good hands-on experience review of the
two.

In short

* I missed the date on the article, sorry
* mysql goes faster but degrades faster
* mysql when it borks usually leaves data intact
* postgress goes slower but degrades more gracefully
* postgress when it borks sometimes does bad bad things to the data
* PG and MySQL are working towards each other's strengths.
* overview of features, already hashed here

So, given real world experience saying PG borks the data on
fails.... doesn't look promising.

OTOH, that article was then, now is now. YMMV.


David