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.works
    link
    fedilink
    English
    arrow-up
    3
    ·
    edit-2
    12 hours 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.