• msage@programming.dev
      link
      fedilink
      arrow-up
      5
      ·
      1 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
      • dan@upvote.au
        link
        fedilink
        arrow-up
        3
        ·
        1 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?