this post was submitted on 11 Jan 2026
294 points (97.4% liked)

Selfhosted

58807 readers
870 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 posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

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

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

  7. No low-effort posts. This is subjective and will largely be determined by the community member reports.

Resources:

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

Questions? DM the mods!

founded 2 years ago
MODERATORS
top 50 comments
sorted by: hot top controversial new old
[–] JoMiran@lemmy.ml 160 points 3 months ago (28 children)

MySQL belongs to Oracle. That's literally all you need to.know in order to avoid it.

[–] FlowerFan@piefed.blahaj.zone 47 points 3 months ago (1 children)

how did the joke go? "one rich asshole called larry ellison"?

[–] ijhoo@lemmy.ml 12 points 3 months ago (1 children)
[–] slazer2au@lemmy.world 24 points 3 months ago

It spells Oracle.

[–] anomnom@sh.itjust.works 8 points 3 months ago (4 children)

Isn’t that the point of Postgresql. It’s basically an open source version of MySQL.

I’m sure there are some proprietary nonsense that MySQL has, but I’ve never needed it in 17 years

[–] sobchak@programming.dev 26 points 3 months ago (1 children)

Postgres is basically an open source version of Oracle DB. Much more featureful than MySQL. I believe Oracle bought MySQL just to kill it.

[–] msage@programming.dev 8 points 3 months ago

MySQL always sucked ass.

PostgreSQL went in a different direction, started with best support of the SQL standard, then optimized everything to make it fast.

Postgres has/had the best SQL standard support out of every server, open-source or not.

MySQL was at the other end, only started catching up after Oracle bought it.

[–] Eyekaytee@aussie.zone 25 points 3 months ago

afaik MariaDB is the open source version of MySQL

[–] Jajcus@sh.itjust.works 23 points 3 months ago (1 children)

That is an insult to PostgreSQL. PostgreSQL was fully featured relational database even before it implemented SQL. It started much earlier tha MySQL.

And MySQL didn't have proper transactions or data integrity constraints (including foreign keys) for long time, while calling itself an 'SQL database'.

load more comments (1 replies)
load more comments (1 replies)
load more comments (26 replies)
[–] slacktoid@lemmy.ml 61 points 3 months ago (1 children)

Stop using mysql, you have postgres.

[–] possiblylinux127@lemmy.zip 21 points 3 months ago (2 children)
[–] call_me_xale@lemmy.zip 33 points 3 months ago (1 children)

Hell, even SQLite is good enough for most small projects.

[–] dan@upvote.au 23 points 3 months ago* (last edited 3 months ago) (4 children)

SQLite is underrated. I've used it for high traffic systems with no issues. If your system has a large number of readers and a small number of writers, it performs very well. It's not as good for high-concurrency write-heavy use cases, but that's not common (most apps read far more than they write).

My use case was a DB that was created during the build process, then read on every page load.

load more comments (4 replies)
[–] immobile7801@piefed.social 10 points 3 months ago (2 children)

FWIW mariadb was bought by a private equity firm in 2024

load more comments (2 replies)
[–] herseycokguzelolacak@lemmy.ml 46 points 3 months ago (1 children)

Didn't Postgresql effectively win the database wars? Why use anything else?

[–] dogs0n@sh.itjust.works 26 points 3 months ago (2 children)

Postgres or sqlite are the only ones I ever consider nowadays.

[–] Takios@discuss.tchncs.de 8 points 3 months ago (1 children)

If only the upgrade process wasn't so annoying with postgres...

load more comments (1 replies)
load more comments (1 replies)
[–] MrSoup@lemmy.zip 45 points 3 months ago* (last edited 3 months ago) (1 children)

MariaDB >>>

I've been using it since ever on my rpi because they say it's easier on resources

[–] YurkshireLad@lemmy.ca 13 points 3 months ago (1 children)

Who are “they”?

We use MariaDB at work but I don’t know why it was originally chosen over PostgreSQL, as that was before my time.

load more comments (1 replies)
[–] melfie@lemy.lol 43 points 3 months ago* (last edited 3 months ago) (1 children)

Oracle sees itself as an activist organization, one whose goal is the advancement of the Israeli colonization project. Safra Catz, the company’s Israeli-American CEO, bluntly explained that any employees uncomfortable with supporting a genocide should simply quit. “We are not flexible regarding our mission, and our commitment to Israel is second to none” (source)

Hmm, MySQL or PostgreSQL—how will we ever decide which one to pick.

load more comments (1 replies)
[–] schnurrito@discuss.tchncs.de 36 points 3 months ago (14 children)

Are there real advantages to using either MySQL or MariaDB instead of PostgreSQL?

No. But there are a number of advantages of using PostgreSQL over the others.

load more comments (13 replies)
[–] Shimitar@downonthestreet.eu 32 points 3 months ago

If you don't want to use postgresql for some obscure reason use MariaDB real open source MySQL drop in replacement.

[–] 800XL@lemmy.world 29 points 3 months ago

What year is this? No one should be using Mysql since MariaDB came about.

[–] 0x0@lemmy.zip 27 points 3 months ago

No one should be using MySQL since 2010.

[–] BrilliantantTurd4361@sh.itjust.works 26 points 3 months ago (1 children)

Why would anyone ever choose mysql over postgres?

[–] Scrollone@feddit.it 7 points 3 months ago (4 children)

MySQL has been the "default" choice for a long time for PHP programmers. I don't know why.

[–] whoisearth@lemmy.ca 9 points 3 months ago* (last edited 3 months ago)

It used to be free with less of a barrier to entry than postgres

[–] Evotech@lemmy.world 8 points 3 months ago (1 children)
load more comments (1 replies)
load more comments (2 replies)
[–] UnknownMp@lemmy.world 22 points 3 months ago

Perhaps MariaDB is a better choice.

[–] ikidd@lemmy.world 22 points 3 months ago (1 children)

What rock do you live under if you're using MySQL over MariaDB?

load more comments (1 replies)
[–] dan@upvote.au 9 points 3 months ago

MariaDB is not always a drop-in replacement. There's several features that MySQL has that MariaDB doesn't, especially related to the optimizer (for some types of queries, MySQL will give you a more optimized execution plan compared to MariaDB). It's also missing some newer data types, like JSON (which indexes the individual fields in JSON objects to make filtering on them more efficient).

MariaDB and MySQL are both fine. Even though MySQL doesn't receive as much development any more, it doesn't really need it. It works fine. If you want a better database system, switch to PostgreSQL, not MariaDB.

[–] possiblylinux127@lemmy.zip 6 points 3 months ago

That's why I moved to MSSQL

/s

load more comments
view more: next ›