I did know when I set it up, but I can't remember right now. I can easily go check though.
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.
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!
That’s how I’d answer if I set something up years ago and it was stable and never required me to come tinker with it.
Mine is managed hosted so I don't know.
Are people here trying to "I run arch btw" database services.
Who cares.
I'm only on MariaDB because I have brain worms, I have so little data on there SQLite would have been fine. 🪱 🪱 🪱
SQLite actually has incredible performance these days. But I get your point :)
I use Postgres, because MySQL touched me inappropriately as a kid and MariaDB is too similar. Oh, and also because it's what I use at work.
I don’t think it matters
You could deploy a container and not know what DB is used
They really push you to install the aio container so it's not surprising to me.
There could be multiple factors. For example, I have a Nextcloud instance that is fully managed by Hetzner, and I didn't bother to find out what database it uses...
That's because they push the all in one container.
People don't care and/or haven't looked at the serverinfo page. That actually mentions the type of database in use.
So the "I don't know" option was probably just the easiest.
I think that's really beautiful.
Should've specifically asked the operators/hosters if they need a better answer. But this has more engagement so
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.
My instance did required me to fix some db issue after an update(it still works but the fix was recommended*). So I knew I am using mariadb. Its not super smooth sailing.
East or West, SQLite is the best.
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.
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 is fine for small amounts of data and very few users. The bottleneck with Nextcloud is almost never the database.
The more shocking is that one guy who KNOWS it's sqlite, but ain't afraid to admit it!