Topic: PostGre vs MySQL
I've written some very involved databases that I use at home primarily for my own use (for now) in MySQL - I'm fluent in DDL and DDM and consider myself almost expert in writing a query of any complexity from databases, but as I'm getting into rails, I'm using Heroku and they use PostGre
I've done some research online and found some comparisons between the two but they are mostly performance issues. I'm wondering if anyone can point me to a 'functional' comparison. What's the difference in SQL language, if any, of PostGre and MySQL or is it purely performance based.
My primary databases are sports statistics related, NBA and MLB so there's a lot of involved table relationships that I don't want to mess up shifting to postgre
Last edited by Jemagee (2013-03-18 11:35:36)