Happy New Year everyone. I'm glad to see its finally 2009. Barack Obama is now our president. Even if you did not vote for him, its fantastic to see a peaceful transition of power, unlike in 2000.
Anyway, I've decided to switch databases, from MySQL to Postgres.
Why would I do that?
It's disconcerting to see Monty Widenus complain about Sun shipping MySQL 5.1 out the door with crashing bugs.
Also, I also am uneasy with Oracle owning the core database engine behind MySQL.
I know that MySQL is working on the Falcon Database engine for version 6, but i have non idea when version 6 will be released.
Lastly, MySQL keeps all database metadata in a MyISAM table. Seriously! WTF? A database should keep it's own data in a storage engine that has transactions and is ACID compliant.
A catalyst for this change is a gift I received for christmas: Enterprise Rails by Dan Chak
It is probably one of the top programming books i've read in a long time (and for those of you who know me, I read a lot of programming books). I changed over my Beerbin website to Postgres I'm in the process of doing the same for the 3 mephisto blogs I administer, including this one.
The EnterpriseDB tools for Mysql to Postgres migration are excellent. I'll try to release some of my scripts to my github account.
Finally, I've noticed that there are not any postgresql user groups in Chicago. I think it would be cool to have one



