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
[-] Max_P@lemmy.max-p.me 78 points 1 year ago

As someone that admins hundreds of MySQL at work, I'd go with PostgreSQL.

[-] pageflight@lemmy.world 28 points 1 year ago

Yeah, every time I find some weird annoying behavior or some missing feature in MySQL, PostgreSQL is doing it right.

That said, also ask yourself if you really need a relational database, or whether an object store or append-only / timeseries db would fit better.

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

Selfhosted

59860 readers
608 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:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam.

  3. Posts here are to be centered around self-hosting. Please ensure it is clear in your post how it relates to self-hosting.

  4. Don't duplicate the full text of your blog or git here. Just post the link for folks to click.

  5. Submission headline should match the article title.

  6. No trolling.

Resources:

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

Questions? DM the mods!

founded 3 years ago
MODERATORS