lawrence@lemmy.worldM to Comic Strips@lemmy.world · 4 months agoLinux processeslemmy.worldimagemessage-square67fedilinkarrow-up1571arrow-down118
arrow-up1553arrow-down1imageLinux processeslemmy.worldlawrence@lemmy.worldM to Comic Strips@lemmy.world · 4 months agomessage-square67fedilink
minus-squaremsage@programming.devlinkfedilinkarrow-up65arrow-down5·4 months agoFuck MySQL, all my homies hate MySQL. Postgres is the way to go.
minus-squaremsage@programming.devlinkfedilinkarrow-up14·4 months agoYes, Maria too. Postgre is the way
minus-squaredanAlinkfedilinkarrow-up1·4 months agoI’m not sure what the future of MariaDB is… It lacks a bunch of newer MySQL features, and they’ve deviated far enough that I don’t know if they can cleanly backport them from MySQL any more.
minus-squareAwkwardLookMonkeyPuppet@lemmy.worldlinkfedilinkEnglisharrow-up22·4 months agoIt was you! You killed it.
minus-squaremsage@programming.devlinkfedilinkarrow-up8·4 months agoI do admit to moving the company cluster from MySQL to Postgres. But only most of the traffic, some traces still remain, so the original MySQL still works
minus-squaremsage@programming.devlinkfedilinkarrow-up5·4 months agoI did two rounds of very long presentations comparing those two systems. Personal reasons: SQL standard support is still very weak lack of WAL array support weird replication support utf8mb4 mess took too long to resolve many things started to get better only after Oracle takeover
minus-squaredanAlinkfedilinkarrow-up3·4 months ago lack of WAL Isn’t that what the binlog is? array support This annoys me too. It’s not quite the same, but native JSON support landed in MySQL 5.7.8. It’s stored in a binary format. weird replication support How does PostgreSQL do it?
minus-squaremsage@programming.devlinkfedilinkarrow-up3·4 months agoNo, it’s not proprietary, it just sucks.
Fuck MySQL, all my homies hate MySQL.
Postgres is the way to go.
“MariaDB”
Yes, Maria too.
Postgre is the way
I’m not sure what the future of MariaDB is… It lacks a bunch of newer MySQL features, and they’ve deviated far enough that I don’t know if they can cleanly backport them from MySQL any more.
It was you! You killed it.
I do admit to moving the company cluster from MySQL to Postgres.
But only most of the traffic, some traces still remain, so the original MySQL still works
why?
I did two rounds of very long presentations comparing those two systems.
Personal reasons:
Isn’t that what the binlog is?
This annoys me too. It’s not quite the same, but native JSON support landed in MySQL 5.7.8. It’s stored in a binary format.
How does PostgreSQL do it?
Because it’s proprietary
No, it’s not proprietary, it just sucks.