News for hackers. Stuff that matters.
Re:MongoDB is to NoSQL like MySQL to SQL - in the most harmf... by asdasf on Tuesday November 12, 2013 @02:45PM (#6720406)
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

Re:MongoDB is to NoSQL like MySQL to SQL - in the most harmf... by fleitz on Wednesday November 13, 2013 @01:17AM (#6723676)
You forgot silent data loss.