Hey, Threadiverse! I’m looking for informed opinions on database choices.

I can stand up an Internet-facing application and have it use either MySQL or PostgreSQL. Which is the better choice, and why do you think so?

Thanks!

    • DeadMartyr@lemmy.zipEnglish
      0·
      2 years ago

      I used MariaDB for school projects, what exactly is wrong with it? Asking because I’m just unaware

        • sugar_in_your_tea@sh.itjust.worksEnglish
          1·
          2 years ago

          Generally speaking, if a professor recommends something, it probably sucks. Their information is incredibly outdated and is usually whatever they used in their own undergrad program.

          At school I learned:

          • Java
          • PHP
          • MySQL
          • C#
          • C++
          • Racket (Lisp)

          Each of those has a better alternative, with C# being the least bad. For example:

          • Java -> Kotlin
          • PHP -> Python
          • MySQL -> SQLite or Postgres
          • C# -> Python (desktop QT GUIs) or web stack (e.g. Tauri for desktop web stack)
          • C++ -> Rust (non-games) or a game engine
          • Lisp -> Haskell

          Formal education is for learning concepts, learn programming languages and tools on your own.

        • Strit@lemmy.linuxuserspace.showEnglish
          0·
          2 years ago

          This sounds like a smear campaign from a competitor.

          I’ve been using mysql and mariadb in my homelab for years and have not enountered any issues. I don’t really know postgresql, so if I was to choose one, I’d go with MySQL/MariaDB.

          • dallen@programming.devEnglish
            0·
            2 years ago

            The question was for an internet facing application, not a homelab.

            As someone who has dealt with MariaDB in production, I would certainly look elsewhere. Haven’t had any colleagues who would disagree…

          • earmuff@lemmy.dbzer0.comBannedEnglish
            01·
            2 years ago

            Smear campaign with an open source product? Are you sure you still have a working organ between your ears?

            That being said, my recommendation is based on using databases in big data environments for 15 years. But I am glad that your home lab is working fine with MariaDB. Does not mean it is a good product. And your comment just proves my point.