The more shocking is that one guy who KNOWS it's sqlite, but ain't afraid to admit it!
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!
Whatever the docker compose file that I found had
"18% of car owners don't know their brake fluid DOT rating."
That is actually good news. Means that people more likely to be "normies" are adopting an alternative solution.
I can confirm I'm a newer user (not a normie) to Nextcloud and I don't know or really care what it uses because it works so I haven't had to learn what it is or how to debug it.
If you're running it in a prebuilt container, as long as it works it shouldn't matter and you don't need to care.
Of course, when your database gets corrupted after Nextcloud updates because you had an app running that isn't supported in the new version, it will suddenly matter a lot.
I‘m using a hosted Nextcloud instance from Hetzner and I have no idea what this is running on either. There’s a significant number of people who didn’t set up their Nextcloud instance, so people not knowing what it’s running on isn’t too surprising.
I write software for a living, and have worked with all 3 database options in the past. I don't know what DB backend my nextcloud server is using, nor do I care.
Yeah, that is the kind of concern for the service developer or a very opinionated sys admin. For self-hosting, few people will reach the workload where such a decision has any material or measurable impact.
Exactly. Unless you are actively doing maintenance, there is no need to remember what DB you are using. It took me 3 minutes just to remember my nextcloud setup since it's fully automated.
It's the whole point of using tiered services. You look at stuff at the layer you are on. Do you also worry about your wifi link-level retransmissions when you are running curl?
I have five users, max, and barely any files. I don't know which one Nextcloud AIO uses and I don't care. There's no wrong answer for such a small deployment. It uses whatever database Nextcloud felt was sensible as the default. They know more about picking the right tool for their requirements than I do.
If I'm building something for myself, then I care.
I also have no idea if my place has PVC or galvanized steel plumbing; or its designed electrical load. Why should users care about the DBMS.
The rule of internet polls is that the funniest answer is always over-represented.
Every person using a computer should know what their filesystem is and what database they are using. Otherwise they are fools.
Can you believe kids don’t know what NTFS or APFS are these days?! Stupid iPad babies.
Haha at some point it did matter to regular folks though. I remember in Junior high when I would try to pirate games or software on Windows, I learned the big difference between fat32 and the new filesystem Microsoft released, NTFS because I couldn't download files larger than 4GB on fat32.
It’s important if you’re using flash drives across platforms though that’s pretty rare these days too. My wife has run into this problem by formatting as ExFAT (GUID partition table) when print shops’ terrible machines only support FAT32 and/or MBR partition tables.
Thankfully macOS at home understands ExFAT otherwise those formatted drives from her Windows work computer wouldn’t even work.
Theres heaps of hosted nextcloud services. Those users wouldn't know.
Nextcloud is pushed as an easy to use docker setup these days, heck most people I know who "use" it don't do much with it at all so what database it is using is gonna be way back in their list of priorities...
Plus the users outweigh the admins surely (as in those that just install then forget)
Isn't that the whole point of containerised solutions? Having some pre-setup, auto-updating solution with very little requirement to dive into the details like what your database is and which dependencies you need to manage...
What's a computer ?
my computer is really slow. where can i download more rams?
Enable hugepage allocation, it will deduplicate memory chunks and save you lotsaram Especially good with an hypervisor desktop
*18% of the people who answered a poll on Mastodon
It's funny that the headline frames it as "a big number" when in reality majority of users don't know what database they're using and probably don't even know what a database is. Such polls aren't useless but you always get skewed results towards the more technical population. They would have to create a poll inside the nextcloud webapp to get more balanced results.
I mean.. I set it up many many years ago... Without looking it up I can also just guess.
East or West, SQLite is the best.
Honestly, does it matter to a regular user?
There will be some that do matter, if I were to run NC I would use Lite because why throw the data to another process just to write it to a disk when I only have a single node.
. >18% of people running next cloud are not backing it up.
Where are you getting that from? The fastest and easiest way to back up any server is a full filesystem backup, especially if you're using something like zfs or btrfs.
Since Nextcloud stores your actually data on the disk, it doesn’t actually matter all that much tbh