Open Menu
AllLocalCommunitiesAbout
lotide
AllLocalCommunitiesAbout
Login

Stop using MySQL in 2026, it is not true open source

⁨170⁩ ⁨likes⁩

Submitted ⁨⁨8⁩ ⁨hours⁩ ago⁩ by ⁨otto@programming.dev⁩ to ⁨selfhosted@lemmy.world⁩

https://optimizedbyotto.com/post/reasons-to-stop-using-mysql/

source

Comments

Sort:hotnewtop
  • BrilliantantTurd4361@sh.itjust.works ⁨54⁩ ⁨minutes⁩ ago

    Why would anyone ever choose mysql over postgres?

    source
  • JoMiran@lemmy.ml ⁨6⁩ ⁨hours⁩ ago

    MySQL belongs to Oracle. That’s literally all you need to.know in order to avoid it.

    Image

    source
    • anomnom@sh.itjust.works ⁨1⁩ ⁨hour⁩ 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

      source
      • sobchak@programming.dev ⁨43⁩ ⁨minutes⁩ 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.

        source
    • FlowerFan@piefed.blahaj.zone ⁨6⁩ ⁨hours⁩ ago

      how did the joke go? “one rich asshole called larry ellison”?

      source
    • Psythik@lemmy.world ⁨6⁩ ⁨hours⁩ ago

      I can’t keep track of all this shit we’ve csnceled. The hell did Oracle do?

      source
      • JoMiran@lemmy.ml ⁨5⁩ ⁨hours⁩ ago

        Hatred of Oracle predates “cancelling” by decades. Oracle is and has always been one of, if not the most disgusting and vicious companies in tech. They kill everything they touch.

        If you need a political component, then Oracle = Larry Ellison, but Oracle hate predates and supercedes the American political slide into fascism.

        source
        • -> View More Comments
      • non_burglar@lemmy.world ⁨5⁩ ⁨hours⁩ ago

        When they bought Sun, they:

        • killed Solaris, effectively
        • tried to kill zfs too
        • nearly killed mysql with licensing audits
        • became borderline evil with licensing practices
        • acted like complete assholes in court, holding up cases for years
        source
        • -> View More Comments
      • iturnedintoanewt@lemmy.world ⁨5⁩ ⁨hours⁩ ago

        news.ycombinator.com/item?id=34249580

        source
        • -> View More Comments
      • forrgott@lemmy.zip ⁨4⁩ ⁨hours⁩ ago

        Why would you keep track? Can’t form your own opinions?!

        And what the fuck hasn’t Oracle done? Like, seriously, they’ve been a known bad actor for literally decades now…

        source
        • -> View More Comments
      • jubilationtcornpone@sh.itjust.works ⁨4⁩ ⁨hours⁩ ago

        “Lets use Oracle DB for that.”

        Statements made by the utterly deranged.

        source
      • fizzle@quokk.au ⁨5⁩ ⁨hours⁩ ago

        I don’t know the actual reason, but I personally get a bad vibe every time I see the logo because usually it means I’m trying to install or fix some java bullshit, which never goes well.

        source
  • melfie@lemy.lol ⁨2⁩ ⁨hours⁩ ago

    Oracle sees itself as an activist organization, one whose goal is the advancement of the Israeli colonization project. Safra Catz, the company’s Israeli-American CEO, bluntly explained that any employees uncomfortable with supporting a genocide should simply quit. “We are not flexible regarding our mission, and our commitment to Israel is second to none”

    Hmm, MySQL or PostgreSQL—how will we ever decide which one to pick.

    source
  • slacktoid@lemmy.ml ⁨6⁩ ⁨hours⁩ ago

    Stop using mysql, you have postgres.

    source
    • possiblylinux127@lemmy.zip ⁨5⁩ ⁨hours⁩ ago

      And mariaSQL

      source
      • immobile7801@piefed.social ⁨2⁩ ⁨hours⁩ ago

        FWIW mariadb was bought by a private equity firm in 2024

        source
        • -> View More Comments
      • call_me_xale@lemmy.zip ⁨5⁩ ⁨hours⁩ ago

        Hell, even SQLite is good enough for most small projects.

        source
        • -> View More Comments
  • MrSoup@lemmy.zip ⁨8⁩ ⁨hours⁩ ago

    MariaDB >>>

    source
    • YurkshireLad@lemmy.ca ⁨6⁩ ⁨hours⁩ ago

      Who are “they”?

      We use MariaDB at work but I don’t know why it was originally chosen over PostgreSQL, as that was before my time.

      source
  • schnurrito@discuss.tchncs.de ⁨7⁩ ⁨hours⁩ ago

    Are there real advantages to using either MySQL or MariaDB instead of PostgreSQL?

    source
    • jubilationtcornpone@sh.itjust.works ⁨6⁩ ⁨hours⁩ ago

      No. But there are a number of advantages of using PostgreSQL over the others.

      source
    • kumi@feddit.online ⁨2⁩ ⁨hours⁩ ago

      Operating and securing Postgres is a steeper learning curve.

      source
    • Rikj000@discuss.tchncs.de ⁨6⁩ ⁨hours⁩ ago

      Yeah,
      I did a speed test comparison between Oracle MySQL and MariaDB MySQL,
      MariaDB is about 10 times faster.

      FYI: When Oracle bought MySQL a lot of developers left and created MariaDB, so the brains behind the project moved, and in the meantime Oracle did a great job of fucking things up.

      source
      • schnurrito@discuss.tchncs.de ⁨6⁩ ⁨hours⁩ ago

        That’s not what I asked. I asked about a comparison of both of them to PostgreSQL.

        source
        • -> View More Comments
    • roguelazer@lemmy.world ⁨7⁩ ⁨hours⁩ ago

      MySQL often has moderately higher performance (particularly for workloads where you want your data clustered by PK, which is how InnoDB is natively structured) and its replication system is much more flexible than either of PostgreSQL’s.

      source
    • illusionist@lemmy.zip ⁨7⁩ ⁨hours⁩ ago

      Depends on the task but for general usage there is no big difference. You would choose one over the other if you need one for work.

      source
  • dan@upvote.au ⁨5⁩ ⁨hours⁩ ago

    MariaDB is not always a drop-in replacement. There’s several features that MySQL has that MariaDB doesn’t, especially related to the optimizer (for some types of queries, MySQL will give you a more optimized execution plan compared to MariaDB). It’s also missing some newer data types, like JSON (which indexes the individual fields in JSON objects to make filtering on them more efficient).

    MariaDB and MySQL are both fine. Even though MySQL doesn’t receive as much development any more, it doesn’t really need it. It works fine. If you want a better database system, switch to PostgreSQL, not MariaDB.

    source
  • GreenKnight23@lemmy.world ⁨1⁩ ⁨hour⁩ ago

    wank bank

    source
    • tacosanonymous@mander.xyz ⁨57⁩ ⁨minutes⁩ ago

      Dude. You never finish.

      source
  • possiblylinux127@lemmy.zip ⁨5⁩ ⁨hours⁩ ago

    That’s why I moved to MSSQL

    /s

    source
  • fizzle@quokk.au ⁨5⁩ ⁨hours⁩ ago

    I didn’t know this was ever in question?

    Also stop calling it “my sequel”

    source
    • TrickDacy@lemmy.world ⁨4⁩ ⁨hours⁩ ago

      stop calling it “my sequel”

      Why?

      source
      • frongt@lemmy.zip ⁨2⁩ ⁨hours⁩ ago

        Sequel is Microsoft. S-Q-L is Linux.

        source
        • -> View More Comments
  • Grandwolf319@sh.itjust.works ⁨7⁩ ⁨hours⁩ ago

    But but but, it has the word “my” in it

    /s

    source
    • folekaule@lemmy.world ⁨7⁩ ⁨hours⁩ ago

      Both MySQL and MariaDb are named after the developer’s daughters.

      source
  • ianhclark510@lemmy.blahaj.zone ⁨6⁩ ⁨hours⁩ ago

    Apache Phoenix: allow me to introduce myself

    source
    • AnUnusualRelic@lemmy.world ⁨3⁩ ⁨hours⁩ ago

      Who?

      source