• anomnom@sh.itjust.works
    link
    fedilink
    English
    arrow-up
    14
    arrow-down
    7
    ·
    15 hours ago

    Isn’t that the point of Postgresql. It’s basically an open source version of MySQL.

    I’m sure there are some proprietary nonsense that MySQL has, but I’ve never needed it in 17 years

    • Jajcus@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      10
      ·
      5 hours ago

      That is an insult to PostgreSQL. PostgreSQL was fully featured relational database even before it implemented SQL. It started much earlier tha MySQL.

      And MySQL didn’t have proper transactions or data integrity constraints (including foreign keys) for long time, while calling itself an ‘SQL database’.

      • anomnom@sh.itjust.works
        link
        fedilink
        English
        arrow-up
        1
        ·
        3 hours ago

        Thank you, I never had time to read up on its history when I was busy smashing out sites on stupid deadlines with constant last minute changes and morons for project managers.

    • sobchak@programming.dev
      link
      fedilink
      English
      arrow-up
      24
      ·
      14 hours ago

      Postgres is basically an open source version of Oracle DB. Much more featureful than MySQL. I believe Oracle bought MySQL just to kill it.

      • msage@programming.dev
        link
        fedilink
        English
        arrow-up
        9
        ·
        8 hours ago

        MySQL always sucked ass.

        PostgreSQL went in a different direction, started with best support of the SQL standard, then optimized everything to make it fast.

        Postgres has/had the best SQL standard support out of every server, open-source or not.

        MySQL was at the other end, only started catching up after Oracle bought it.