• @msage
    link
    601 month ago

    Fuck MySQL, all my homies hate MySQL.

    Postgres is the way to go.

      • @msage
        link
        141 month ago

        Yes, Maria too.

        Postgre is the way

      • @[email protected]
        link
        fedilink
        11 month 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.

      • @msage
        link
        81 month 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

      • @msage
        link
        51 month ago

        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
        • @[email protected]
          link
          fedilink
          31 month 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?

        • @msage
          link
          31 month ago

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