Internet Bandaid   [RSS Feed]

NOTES : Mysql 5.5+ vs. PostgreSQL 9.0+

without comments

I’ve been thinking about whether to start developing with Postgresql. I was even entertaining the idea of replacing the mysql database of one of our Drupal projects with postgresql database.

My primary motivators for considering this were:
- a business decision – there are some investors and business individuals, who at the mere mention of mysql, thinks your product is cheap and not scalable
- the reputation mysql 4.x attracted as a very poor relational database technology if you expect it to be ACID compliant

I did a little research and talked to a few people. Turns out mysql 5.5 has come a long way to being a database that might support medium to larger organization needs. From what I’ve read so far, performance of postgresql 9.x isn’t that much greater than mysql 5.5+. See here. Additionally, there are a lot more open source tools built with support for mysql, but not necessarily postgresql. This is particularly true of drupal modules.

So now, I don’t have a very strong argument for migrating existing projects off of mysql over to postgresql.

Written by John Lai

January 14th, 2014 at 12:53 am

Posted in Uncategorized

Start Mission - Project management and invoicing

Leave a Reply