3 ms·
In 2019. A LOT of people want MySQL over Postgres because of ignorance about how far Postgres has came and they don't know/care. I try to explain why I like tr
by leetrout 8y ago
In 2019.
A LOT of people want MySQL over Postgres because of ignorance about how far Postgres has came and they don't know/care. I try to explain why I like transactional DDL and the guardrails that come with Postgres.
With MySQL you end up having to use Percona to get a really robust DB setup with proper tooling that compares to Postgres in my experience.
Both, of course, have plenty of known and unknown knobs you can turn to your liking and can make either database appear to be better by any number of metrics for your use case.
- bpye 8y agoAnd I'm sure one day some new DB will pop up, and for most workloads it'll be better. People will still use PostgreSQL because it was the right choice in 2019. So the cycle will repeat...
- leetrout 8y agoWithout a doubt. Lots of movement around specializations (ML/AI datasets) and decentralization... When the tasks we're solving are fundamentally different than I expect the tools to support those tasks will be fundamentally different, too.
- purple_ducks 8y ago> A LOT of people want MySQL over Postgres because of ignorance or you know, for multi master cluster pretty much out of the box. Gallera DB.
- ricklepick 8y agoIt's rarely as nice in reality as it sounds on paper though... Gallera DB setups aren't easy, and still have complex issues.