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

Hardly anyone ever says mysql is better. Postgres has a lot of nice features, But they're still a hell of a lot more people out there with mySQL experience.

If for some reason you really want to go mysql I would urge you to look into percona and percona tools. It's incredibly fast super optimized. The tools let you do backups that my sequel could only dream of.

That said, if you don't have any strong needs for mySQL, and you don't have any experience with it I would probably start picking up postgres.

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

Selfhosted

61189 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