4 ms·
Counterpoints: - using pg arrays is awesome, and for many access patterns is more performant and equally normalized - MySQL is mostly quite correct, though I d
by pvh 14y ago
Counterpoints:
- using pg arrays is awesome, and for many access patterns is more performant and equally normalized
- MySQL is mostly quite correct, though I disagree with some of the implicit casting of values to integers and some nuances of GROUP BY. That said, operationally speaking, I'd say MySQL replication is less good and can get out of sync in awful ways, there are fewer awesome features (I made some slides: http://love-your-database.heroku.com/ http://love-your-database.heroku.com/), and the storage engines mean you have to choose between useful features and like, not losing your data, man.
- gbog 14y ago> some nuances of GROUP BY I won't call them nuances. SQL tries hard to be very close to set theory, and not just for the sake of it. In set theory, you have no nuances, you have only one possible answer to a question, and MySQL is like a bad student how do not understand why, in maths, you should never affirm something that is not 100% sure and proven.