3 ms·
>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?
by ahmedk92 10y 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?
- dijit 10y agoSure, but adding too many sources will make me seem snide or bitter. But as an example: https://www.youtube.com/watch?v=emgJtr9tIME 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_autocommit https://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_a... http://grimoire.ca/mysql/choose-something-else http://grimoire.ca/mysql/choose-something-else https://blog.ionelmc.ro/2014/12/28/terrible-choices-mysql/ 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-string.html 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.html 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.