Submitted 6 months ago by otto@programming.dev to selfhosted@lemmy.world
https://programming.dev/pictrs/image/77738dcc-fb16-471e-918c-b4162d99d54e.png
Nextcloud asked in a poll at mastodon.social/…/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?
The more shocking is that one guy who KNOWS it’s sqlite, but ain’t afraid to admit it!
East or West, SQLite is the best.
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 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.
I can’t decide if you don’t know what you’re talking about or you’re just trying to troll me.
This is a fallacious. If you have a very small set of users, what exact data is in the database that you would be upset at losing? Maybe your contacts and your calendar. Which you could back up manually, which might actually be simpler than backing up the database.
I’m sorry, but writing down the data from your organizational program and re-entering it all from scratch is NOT a backup solution.
If you have such scant data to do that, you didn’t need to have nextcould installed in the first place.
TIL that NextCloud can use an external database.
Are you still using sqlite?
Aren’t you? WAL mode has made SQLite better than the alternatives at this point.
Whatever the docker compose file that I found had
What’s a Next Cloud, what came before it? /s
Should’ve specifically asked the operators/hosters if they need a better answer. But this has more engagement so
“18% of car owners don’t know their brake fluid DOT rating.”
It’s awesome that you don’t have to remember what software you’re using underneath. I looked into it before I installed it, but I’d have to check which one I went with. I also have no idea what graphics card I’m using, which headset I’m using, what brand of eyeglass cleaner I’m using etc. I looked into it at the time, made a choice and promptly forgot about why and filled my brain with other things.
If I remembered which database I was running it means that I’d have enough problems with it that I’d look at it a lot.
I think that’s really beautiful.
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.
Theres heaps of hosted nextcloud services. Those users wouldn’t know.
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.
I mean… I set it up many many years ago… Without looking it up I can also just guess.
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)
I don’t think it matters
You could deploy a container and not know what DB is used
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.
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.
Well that’s kind of misleading, right? If they didn’t set one up, then it’s probably SQLite. But if they did set one up, that was years ago, and who cares what it is, if it’s working.
I’ve made a choice a while ago while deploying Nextcloud. Now I don’t care, as I trust myself that I have opted for something reasonable which was hopefully not SQLite
why the hate for SQLite?
SQLite is awesome, but of course not for every project.
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.
If you need to fix something, you should know what it is.
I’ll get that info as soon as something breaks, I guess.
I found this way funnier then I think you meant it… PVC wasn’t persistent volume claim was it?
Unless he installed kubernetes pipes, no.
That’s because they push the all in one container.
You can install NextCloud with snap.
Yeah, and after having dealt with the “I missed a few updates and then the last one put my files out of sync with my schema” Docker issues, I’m very much happy to use the snap. Been on that a couple years and it’s been quite solid, even if I did have to install snapd on my Debian base for it
MariaDB, only know that because I tried to install ampache (got it to work, hated it).
Tbh I don’t even know what to use nextcloud for. Installed aio cause everyone kept talking about it but never found an actual use for it
Who cares.
I’m only on MariaDB because I have brain worms, I have so little data on there SQLite would have been totally fine. 🪱 🪱 🪱
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.
SQLite actually has incredible performance these days. But I get your point :)
Exactly. Who gives a shit?
I mean… I could recite the exact setup of mine in detail, but I’d probably be happier if my brain matter was dedicated to something else. Do not shame the ignorant. Envy them.
The rule of internet polls is that the funniest answer is always over-represented.
…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.
Probably also most of those who don’t know. SQLite is the default option if you don’t set up a database server.
Those who don’t know may be using Nextcloud AIO, which is bundled with Postgres.
sj_zero 6 months ago
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.