Hacker News new | ask | show | jobs
by ahmedk92 3732 days ago
>I can't ever go back to using mysql after administering oracle, mssql and postgres

>MySQL is the mongodb of relational database design

Care stating why?

1 comments

Sure, but adding too many sources will make me seem snide or bitter.

But as an example:

https://www.youtube.com/watch?v=emgJtr9tIME MySQL vs PostgreSQL - Why you shouldn't use MySQL

https://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_a...

http://grimoire.ca/mysql/choose-something-else

https://blog.ionelmc.ro/2014/12/28/terrible-choices-mysql/

the fact that https://dev.mysql.com/doc/refman/5.6/en/mysql-real-escape-st... has to exist because https://dev.mysql.com/doc/refman/5.6/en/mysql-escape-string.... doesn't work properly. (this is actually blamed on PHP a lot)

My favorite MySQL gotcha is that if you issue a GRANT statement with a typo in the user's name instead giving a "user does not exist" error it simply creates a new user with the misspelled name.