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!

    • 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.comBannedEnglish
        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.