MySQL: Choose Something Else(grimoire.ca)
grimoire.ca
MySQL: Choose Something Else
http://grimoire.ca/mysql/choose-something-else
4 comments
T-SQL is Microsoft (and Sybase, from whom they bought it) specific implementation. I think you just mean "Standard SQL" everywhere you say "T-SQL".
Previous discussion here: https://news.ycombinator.com/item?id=5122299
This write-up is at least three years old.
1) It's INSANE handling of GROUP BY. In any other RDBMS, a GROUP BY that is missing non-aggregated fields in the result set of the query would throw an error, but MySQL just lets it fly defaulting to some random ass behavior that will return garbage 100% of the time.
2) It was mentioned that it lacks Windowing Functions, which is a HUGE miss, but it also lacks native Recursive Views. The workaround is some horrid mess of self referring variables. Why Recursive views, a T-SQL standard that is in nearly every other adult RDBMS, is lacking here is beyond me. (I know it's not a T-SQL standard database by design, which is just another nail in it's coffin if you ask me.)
I was just reading through a very lengthy StackOverflow question where the poor schmuck was trying to migrate from MSSQL to MySQL to save money. Noone at her shop, including her, had heard of Postgres. It's free. It's been around a hell of a long time. There is a huge community that uses it. And it's T-SQL based. It's just 100% better.
MySQL is some Kool-Aid that we should all just put down and back away from.