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.
Resources:
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
Nextcloud asked in a poll at https://mastodon.social/@nextcloud@mastodon.xyz/115095096413238457 what database its users are running. Interestingly one fifth replied they don't know. Should people know better where their data is stored, or is it a good thing everything is running so smoothly people don't need to know what their software stack is built upon?
I think that's really beautiful.
I set up everything I use "bare metal" or at least in an lxc container I directly build and maintain, but most people don't. Makes a lot of sense, to be honest. A lot of prepackaged software uses databases and nobody has to care exactly what it's up to.
Should've specifically asked the operators/hosters if they need a better answer. But this has more engagement so
East or West, SQLite is the best.
...How come so few people are using SQLite?
Idk, I explicitly set up Postgres, which took extra work since the default is SQLite. I use Postgres for my day job, so it makes sense to me to keep everything the same.
That's quite senseful yes. In the cases where I want to host somewhere that already has a Postgres service going, I just up and use that.
I use the prebuilt Hetzner one and have no idea either.
Yeah. I have used that. And I'm sure most with personal instances that just pressed the "Install NextCloud" button have no clue, including me.
Not sure I understand... Can the type of database be customised during nextcloud installation? If not, then more than 37% gave a wrong answer, which is worse than the 18%?
What's a Next Cloud, what came before it? /s
Before Cloud, obviously.
It's cloud all the way down.
And computers all the way up
Honestly I'm more concerned about those willingly using sqlite.
Unless it has changed a lot over the years, I remember it being orders of magnitude better with MariaDB than sqlite.
SQLite has made huge performance improvements in the last like 3-5 years.
I wouldn’t spin up an enterprise NextCloud with it but for a home NAS serving up to maybe a dozen people it’s more than enough.
Where's the MySQL option? Some of my servers are running MySQL instead of MariaDB because it allowed binding to multiple IP addresses (although I think Maria has implemented this now), and some query plan optimizations were implemented in MySQL but not MariaDB.
Honestly I'm not sure I'd know Immich used Postgres if it didn't outright say so