Re: Justifying a PG over MySQL approach to a project

The arguments against PG are not technical. The biggest advocate for MySQL is actually a very sharp engineer who admits that PG is a superior DB. But MySQL is more popular in the corp and has more formal recognition. So he's saying that the differences aren't "big enoug" to justify using PG.

A statement from an uninterested third party stating that data in a PG DB is more secure, more integrit, more up-time than a MySQL implementation, now THAT would carry weight with the decision maker (who know nothing about DBs, but want that data secure, integrit and available).

Not sure when the decision will be made. But I expect to get physically ill if I have to dismantle the PG implementation and replace it with MySQL.

Dear Santa, All I want for Christmas is to be able to keep my DB.

-----Original Message-----
From: Lincoln Yeoh [mailto:lyeoh(at)pop(dot)jaring(dot)my]
Sent: Sunday, December 20, 2009 10:05 AM
To: Greg Smith; Gauthier, Dave
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Justifying a PG over MySQL approach to a project

At 05:44 AM 12/17/2009, Greg Smith wrote:
>You've probably already found
>http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
>which was my long treatment of this topic (and overdue for an update).
>
>The main thing I intended to put into such an update when I get to
>it is talking about the really deplorable bug handling situation for
>MySQL, which is part of how all the data corruption issues show
>up. There's a good overview of its general weirdness at
>http://www.xaprb.com/blog/2007/08/12/what-would-make-me-buy-mysql-enterprise/
>and the following series of pages lead you through my favorite set of bugs:

More so when Monty himself grumbles about the bug handling situation:

http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html

If people still insist on MySQL, you might want to get it in writing
that it's someone else's decision to use MySQL and not yours ;).

Ten or so years ago MySQL was better than Postgres95, and it would
have been easy to justify using MySQL over Postgres95 (which was
really slow and had a fair number of bugs). But Postgresql is much
better than MySQL now. That's just my opinion of course.

Link