3 ms·
The question for most isn't really "MySQL or NoSQL", but "ACID or not." For most people, ACID means MySQL because PostgreSQL (despite my own affection for it) i
by eropple 15y ago
The question for most isn't really "MySQL or NoSQL", but "ACID or not." For most people, ACID means MySQL because PostgreSQL (despite my own affection for it) is a major, major pain in the ass to work with on a smaller scale (edit: and Oracle costs more than most programmers' houses, so that tends to rule it out in a lot of cases). PostgreSQL tooling is considerably worse than MySQL (phpMyAdmin is damn near ubiquitous and has no reasonable pgsql competitor). Documentation expects you to already be a guru. And there's often just no really compelling performance reason to pick it over MySQL.
And then, when you get to Facebook's scale--though as a coworker just pointed out, Facebook probably isn't particularly ACID-compliant--Postgres is going to have problems that are pretty much the same as those you see in MySQL.
PostgreSQL isn't really "better than" or "an improvement over" MySQL. Different tools, different tasks--though they do have considerable overlap.