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
    8·
    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
        42·
        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.

        • earmuff@lemmy.dbzer0.comEnglish
          33·
          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.