Lemmy at mair.io
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
Otto@programming.dev to Selfhosted@lemmy.worldEnglish · 4 months ago

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

optimizedbyotto.com

external-link
message-square
98
fedilink
  • cross-posted to:
  • technology@lemmy.world
1
external-link

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

optimizedbyotto.com

Otto@programming.dev to Selfhosted@lemmy.worldEnglish · 4 months ago
message-square
98
fedilink
  • cross-posted to:
  • technology@lemmy.world
If you care about supporting open source software, and still use MySQL in 2026, you should switch to MariaDB like so many others have already done.\n
alert-triangle
You must log in or register to comment.
  • melfie@lemy.lol
    link
    fedilink
    English
    arrow-up
    0
    ·
    edit-2
    4 months 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” (source)

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

    • skisnow@lemmy.ca
      link
      fedilink
      English
      arrow-up
      0
      ·
      4 months ago

      wow, I didn’t need any more reasons not to support Oracle but thanks anyway

  • MrSoup@lemmy.zip
    link
    fedilink
    English
    arrow-up
    0
    ·
    edit-2
    4 months ago

    MariaDB >>>

    I’ve been using it since ever on my rpi because they say it’s easier on resources

    • YurkshireLad@lemmy.ca
      link
      fedilink
      English
      arrow-up
      0
      ·
      4 months 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.

      • MrSoup@lemmy.zip
        link
        fedilink
        English
        arrow-up
        0
        ·
        4 months ago

        Blogs and forums back then when I looked it up.
        Can’t remember exactly where (since it’s been a long time ago), but I’m sure more than someone claimed it.

  • UnknownMp@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    Perhaps MariaDB is a better choice.

  • BrilliantantTurd4361@sh.itjust.works
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    Why would anyone ever choose mysql over postgres?

    • Scrollone@feddit.it
      link
      fedilink
      English
      arrow-up
      0
      ·
      4 months ago

      MySQL has been the “default” choice for a long time for PHP programmers. I don’t know why.

      • Evotech@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        4 months ago

        LAMP indeed

        • WhyAUsername_1@lemmy.world
          link
          fedilink
          English
          arrow-up
          0
          ·
          4 months ago

          We need LAPP . Stat!

      • whoisearth@lemmy.ca
        link
        fedilink
        English
        arrow-up
        0
        ·
        edit-2
        4 months ago

        It used to be free with less of a barrier to entry than postgres

      • msage@programming.dev
        link
        fedilink
        English
        arrow-up
        0
        ·
        4 months ago

        Tutorials mostly.

      • Andres@social.ridetrans.it
        link
        fedilink
        arrow-up
        0
        ·
        4 months ago

        @Scrollone @BrilliantantTurd4361 Because it used to be a lot faster than postgresql for smaller sites. MyISAM (https://en.wikipedia.org/wiki/MyISAM) was super lightweight, at the expense of the occasional corrupt database (oops).

        I don’t know how many new people are coming to PHP these days (as opposed to javascript/python/rust/etc), but certainly the older PHP coders grew up using mysql.

  • GreenKnight23@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    wank bank

    • tacosanonymous@mander.xyz
      link
      fedilink
      English
      arrow-up
      0
      ·
      4 months ago

      Dude. You never finish.

  • ianhclark510@lemmy.blahaj.zone
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    Apache Phoenix: allow me to introduce myself

    • AnUnusualRelic@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      4 months ago

      Who?

      • ianhclark510@lemmy.blahaj.zone
        link
        fedilink
        English
        arrow-up
        0
        ·
        4 months ago

        Apache Phoenix

  • Possibly linux@lemmy.zip
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    That’s why I moved to MSSQL

    /s

  • bored_boar_onboard@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    Clearly you can’t use MySQL because it isn’t webscale.

  • dan@upvote.au
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months 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.

  • androidul@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    when is Oracle gonna go Broadcom mode on MySQL, still waiting for the moment 🍿

  • fizzle@quokk.au
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    I didn’t know this was ever in question?

    Also stop calling it “my sequel”

    • TrickDacy@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      4 months ago

      stop calling it “my sequel”

      Why?

      • frongt@lemmy.zip
        link
        fedilink
        English
        arrow-up
        0
        ·
        4 months ago

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

        • surewhynotlem@lemmy.world
          link
          fedilink
          English
          arrow-up
          0
          ·
          4 months ago

          Microsoft’s is “squeal”. Like a pig. When you get the bill.

  • 800XL@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    What year is this? No one should be using Mysql since MariaDB came about.

  • SneakyWeasel@lemmy.ca
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    Wamp anyone? (I think thats what its called, im at work and cant check my pc) Or am i the odd one out.

  • Shimitar@downonthestreet.eu
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    If you don’t want to use postgresql for some obscure reason use MariaDB real open source MySQL drop in replacement.

  • ikidd@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    4 months ago

    What rock do you live under if you’re using MySQL over MariaDB?

    • lechekaflan@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      4 months ago

      Older people about to return to programming, and most of the online tutorials they have are about 20 years old, having no idea an alternative exists.

Selfhosted@lemmy.world

selfhosted@lemmy.world

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !selfhosted@lemmy.world

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don’t control.

Rules:

  1. Be civil: we’re here to support and learn from one another. Insults won’t be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it’s not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don’t duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

  7. No low-effort posts. This is subjective and will largely be determined by the community member reports.

Resources:

  • selfh.st Newsletter and index of selfhosted software and apps
  • awesome-selfhosted software
  • awesome-sysadmin resources
  • Self-Hosted Podcast from Jupiter Broadcasting

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 47 users / day
  • 651 users / week
  • 1.33K users / month
  • 5.53K users / 6 months
  • 0 local subscribers
  • 59.3K subscribers
  • 1.33K Posts
  • 20.6K Comments
  • Modlog
  • mods:
  • Ruud@lemmy.world
  • Loki@lemmy.world
  • CannaVet@lemmy.world
  • devve@lemmy.world
  • HybridSarcasm@lemmy.world
  • HybridSarcasm@lemmy.hybridsarcasm.xyz
  • UI: unknown version
  • BE: 0.19.18
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org