this post was submitted on 12 Aug 2024
552 points (96.9% liked)

Comic Strips

20887 readers
2869 users here now

Comic Strips is a community for those who love comic stories.

The rules are simple:

Web of links

founded 2 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] msage@programming.dev 60 points 1 year ago (3 children)

Fuck MySQL, all my homies hate MySQL.

Postgres is the way to go.

[–] kitnaht@lemmy.world 26 points 1 year ago (2 children)
[–] msage@programming.dev 14 points 1 year ago

Yes, Maria too.

Postgre is the way

[–] dan@upvote.au 1 points 1 year ago

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.

[–] Anticorp@lemmy.world 22 points 1 year ago (1 children)
[–] msage@programming.dev 8 points 1 year ago

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

[–] umbrella@lemmy.ml 8 points 1 year ago (2 children)
[–] msage@programming.dev 5 points 1 year ago (1 children)

I 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
[–] dan@upvote.au 3 points 1 year 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?

[–] kionite231@lemmy.ca -3 points 1 year ago (1 children)
[–] msage@programming.dev 3 points 1 year ago

No, it's not proprietary, it just sucks.