61

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!

you are viewing a single comment's thread
view the rest of the comments
[-] sugar_in_your_tea@sh.itjust.works 4 points 2 years ago* (last edited 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.

this post was submitted on 16 Jan 2025
61 points (100.0% liked)

Selfhosted

61189 readers
283 users here now

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:

Detailed Rules Post

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details. Tags [CBH] or [AIP] are required, see the links in Rule 8 for details.

  8. AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post, and find example disclosures here.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago
MODERATORS