view the rest of the comments
Selfhosted
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:
-
Be civil.
-
No spam.
-
Posts are to be related to self-hosting.
-
Don't duplicate the full text of your blog or readme if you're providing a link.
-
Submission headline should match the article title.
-
No trolling.
-
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.
-
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:
- selfh.st Newsletter and index of selfhosted software and apps
- awesome-selfhosted software
- awesome-sysadmin resources
- Self-Hosted Podcast from Jupiter Broadcasting
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
Yeah, I wasn't trying to say SQLite is universally better. I shouldn't have said best option, I really meant best default. I don't think the majority of users are running a central db, most will just spin-up docker compose files for each service and end up with multiple SQL versions running.
I have had this issue, but it was always easily recoverable. I haven't had the same issues with backups, although a lot of the software I use that's running SQLite has a builtin backup feature, then I just backup that directory to a cloud service.
When an app is using an ORM already, I think they might as well make sure it supports both SQLite and a hosted DB like Postgres
Yeah that's true, in the case of just running a premade compose file sqlite is the better choice for sure