4 ms·

If you don't have need for relational integrity, then MySQL is a liability. MongoDB does not have relational integrity which is one of the reasons why it's fast

by Joakal 15y ago

If you don't have need for relational integrity, then MySQL is a liability. MongoDB does not have relational integrity which is one of the reasons why it's faster. eg Real-time analytics If you need a pre-planned schema from database over making one on the fly (even accidentally), then MySQL is better as MongoDB is schema-less. eg Rapidly changing input If you are worried about Oracle's acquisition of Sun and MySQL (Switching to Postgre is the closest alternative though). MySQL sharding is hard, MongoDB can automate it to a certain extent (MySQL requires third party tools I believe). eg Distributing large datasets Note: Other databases, eg Cassandra can also automate 'sharding' for example.

unicornporn 15y ago
Isn't MariaDB an even closer alternative than Postgre?
- Joakal 15y ago
  I had to look up MariaDB, that's true in the codebase sense from the gist of it. Postgre is more popular than MariaDB I suppose.
- fhars 15y ago
  There is no such thing as "postgre".
stonemetal 15y ago
If you don't have need for relational integrity, then MySQL is a liability. MongoDB does not have relational integrity which is one of the reasons why it's faster. When did Mysql have relational integrity?
- Joakal 15y ago
  For a long time: http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-foreign-keys.html http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-foreign-key...
  - stonemetal 15y ago
    Yes, but it is easily disabled.