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
[-] Dark_Arc@social.packetloss.gg 29 points 1 year ago

PostgreSQL is just better. It's supports transactions on DDL (things like altering table structure) and enforces unique constraints after transactions complete ... so you can actually do a bunch of important stuff (like update your table structure or swap unique values between rows) safely.

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

Selfhosted

59923 readers
842 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