3 ms·
Have you ever used any other database? Literally every single thing you listed as being a plus of mysql is something postgresql and sql server both do better.
by asdasf 13y ago
Have you ever used any other database? Literally every single thing you listed as being a plus of mysql is something postgresql and sql server both do better. Mysql is in no way even close to being on par with non-broken databases. A brief list of some obvious, glaring flaws with mysql that have been actual problems in practice:
no check constraints
views with aggregates are too slow to be used
no expression indexes
triggers don't fire on cascaded actions
no window functions
can't set default values to be the result of a function
no transactional DDL
doesn't have multiple databases, just schemas misnamed as databases
rollbacks are orders of magnitude slower than other RDBMS, and it is interrupted it can corrupt the database
functions can't use prepare/execute, so no dynamic SQL in functions
subqueries are broken: can't modify and select from the same table
functions can't be called recursively (seriously? is this 1962?)
triggers can't alter the table they are firing against
stored procedures can't be invoked from prepare/execute
"slow query" log has a completely useless resolution of seconds
- fleitz 13y agoYou forgot silent data loss.