this post was submitted on 22 Sep 2023
14 points (100.0% liked)
Self Hosted - Self-hosting your services.
506 readers
2 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
- No harassment
- crossposts from c/Open Source & c/docker & related may be allowed, depending on context
- Video Promoting is allowed if is within the topic.
- No spamming.
- Stay friendly.
- Follow the lemmy.ml instance rules.
- Tag your post. (Read under)
Important
Beginning of January 1st 2024 this rule WILL be enforced. Posts that are not tagged will be warned and if not fixed within 24h then removed!
- Lemmy doesn't have tags yet, so mark it with [Question], [Help], [Project], [Other], [Promoting] or other you may think is appropriate.
Cross-posting
- !everything_git@lemmy.ml is allowed!
- !docker@lemmy.ml is allowed!
- !portainer@lemmy.ml is allowed!
- !fediverse@lemmy.ml is allowed if topic has to do with selfhosting.
- !selfhosted@lemmy.ml is allowed!
If you see a rule-breaker please DM the mods!
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
For Seafile, or in general?
I couldn't say why they prefer PostgreSQL over MySQL for Seafile, but it may be just because they know PostgreSQL administration, and don't want to have to learn and remember two different sets of tools. I personally hate administering SQL DBs, and I prefer PSQL in most places because I'm most familiar with it, and even one is too much.
PostgreSQL tends to lead MySQL in feature set: they had geoqueries first, and they added a NoSQL interface a while back. OTOH, many people probably consider this sort of thing to be bloat, and may prefer MySQL/MariaDB for being more lean.
Me, I'm a SQLite guy: no server, no connection strings, no user or permission management, one file to back up.
While you raise valid points I don't really have a preference actually. I self host many services that all depend on a postgres db and it would be overkill to create an extra database just for seafile it's also really easy to manage with a nice interface like pgadmin and i found it overall reliable and it can easily scale up and down according to my needs .
However the main reason i didn't chose MySQL in the first place is simply because i don't trust oracle for keeping MySQL open-source (i'm actually surprised it stayed open source for so long) postgres has been independent for decades so i know they're not gonna give me up
I meant generally, yes. That helps me at least begin to understand it, thanks!