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: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
-
No spam posting.
-
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.
-
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
-
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
-
No trolling.
-
No low-effort posts. This is subjective and will largely be determined by the community member reports.
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!
view the rest of the comments
Hi, it might but I haven't explored that. I'll look into it. Would you want to roll your own SQLite, or just have that containerized instead of postgres?
SQLite doesnt require you to have any service running, the DB is just stored in a file which the program accesses through an SQLite library. I think its the best option for selfhosted software, as its very lightweight and more than performant enough for 99% of these use cases.
Performance isn't the only advantage to a full postgres deployment. I have a central database for all of my self hosted apps which makes it really easy to back it all up.
I've had a lot of problems in the past from software crashes that left sqlite files in a corrupt state, backups where the sqlite file wasn't properly closed leaving it in a weird unlockable state, transactions not completing when swap is used, etc. Besides that sqlite really doesn't play nice with NFS, which is the basis for quite a few cloud storage providers.
"Best option" really depends on what self hosting looks like in your specific setup.
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