The Stormux Lemmy
  • Communities
  • Create Post
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
Otto@programming.dev to Selfhosted@lemmy.worldEnglish · 2 days ago

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

optimizedbyotto.com

external-link
message-square
95
fedilink
1
external-link

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

optimizedbyotto.com

Otto@programming.dev to Selfhosted@lemmy.worldEnglish · 2 days ago
message-square
95
fedilink
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.
  • SneakyWeasel@lemmy.ca
    link
    fedilink
    English
    arrow-up
    0
    ·
    16 hours ago

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

  • bored_boar_onboard@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    17 hours ago

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

  • 0x0@lemmy.zip
    link
    fedilink
    English
    arrow-up
    0
    ·
    20 hours ago

    No one should be using MySQL since 2010.

  • UnknownMp@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    23 hours ago

    Perhaps MariaDB is a better choice.

  • herseycokguzelolacak@lemmy.ml
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 day ago

    Didn’t Postgresql effectively win the database wars? Why use anything else?

    • dogs0n@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      0
      ·
      22 hours ago

      Postgres or sqlite are the only ones I ever consider nowadays.

      • Takios@discuss.tchncs.de
        link
        fedilink
        English
        arrow-up
        0
        ·
        19 hours ago

        If only the upgrade process wasn’t so annoying with postgres…

        • msage@programming.dev
          link
          fedilink
          English
          arrow-up
          0
          ·
          18 hours ago

          What do you mean?

          Stop DB, run pg_upgrade, start it, win?

          Or set up logical replication into newer version, wait for sync, test use-cases, switch write?

          Where do you get better experience?

      • Hawk@lemmynsfw.com
        link
        fedilink
        English
        arrow-up
        0
        ·
        20 hours ago

        See also duckdb and clickhouse for OLAP of course.

  • androidul@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 day ago

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

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

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

  • ikidd@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 day ago

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

    • lechekaflan@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      16 hours 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.

  • Shimitar@downonthestreet.eu
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 day ago

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

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

    Why would anyone ever choose mysql over postgres?

    • Scrollone@feddit.it
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 day ago

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

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

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

      • msage@programming.dev
        link
        fedilink
        English
        arrow-up
        0
        ·
        20 hours ago

        Tutorials mostly.

      • Andres@social.ridetrans.it
        link
        fedilink
        arrow-up
        0
        ·
        1 day 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.

      • Evotech@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 day ago

        LAMP indeed

        • WhyAUsername_1@lemmy.world
          link
          fedilink
          English
          arrow-up
          0
          ·
          22 hours ago

          We need LAPP . Stat!

  • GreenKnight23@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 day ago

    wank bank

    • tacosanonymous@mander.xyz
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 day ago

      Dude. You never finish.

  • melfie@lemy.lol
    link
    fedilink
    English
    arrow-up
    0
    ·
    edit-2
    1 day 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
      ·
      21 hours ago

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

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

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

    That’s why I moved to MSSQL

    /s

  • fizzle@quokk.au
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 day 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
      ·
      1 day ago

      stop calling it “my sequel”

      Why?

      • frongt@lemmy.zip
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 day ago

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

        • surewhynotlem@lemmy.world
          link
          fedilink
          English
          arrow-up
          0
          ·
          1 day ago

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

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.

  • 114 users / day
  • 490 users / week
  • 1.33K users / month
  • 4.23K users / 6 months
  • 0 local subscribers
  • 54.5K subscribers
  • 2.86K Posts
  • 43K 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.9
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org