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
[-] DeadMartyr@lemmy.zip 8 points 2 years ago

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

[-] msage@programming.dev 4 points 2 years ago

Many things, too many to even remember.

Very bad SQL implementation is a good start, still bad replication support (compared to Postgres), various bugs present for too long...

https://www.sql-workbench.eu/dbms_comparison.html this comparison is a bit out of date, but explains a lot

[-] earmuff@lemmy.dbzer0.com 3 points 2 years ago* (last edited 2 years ago)

While there was a time, where those databases were considered “good”, they are only this famous because they have been free or open source for ages. Professors love open source stuff. This does not necessarily mean it is a good product in terms of database functionality. They have been stuck in the old age and simply get outperformed by almost anything. Professors also hate to change their slides and to learn something new. Because their priority is on functionality, not on real world use. And when you want to use a product in the real world, non-functional properties gain a lot of value. One of them is performance.

If you want to have a fast, reliable, open source database, use ClickHouse.

[-] 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.

[-] eutampieri@feddit.it 1 points 2 years ago

Click house is for OLAP workloads

[-] earmuff@lemmy.dbzer0.com 2 points 2 years ago

It was. Now compare the benchmark of OLTP tasks and you will be surprised

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

Selfhosted

61207 readers
254 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