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.
post
That is actually good news. Means that people more likely to be "normies" are adopting an alternative solution.
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.
Will Nextcloud run apps not marked as compatible with that version?
You can specify the behavior in a few places, gui, occ command, config.php. By default no, but if you have an app you want to force in regardless of the version compatibility you can make it so https://help.nextcloud.com/t/help-what-is-app-install-overwrite-for/71523
Bugs still happen. Just did with the most recent version and the polls app and mysql
And if you don't know what database you're running, how are you backing it up?
If you don't know what database you're running, are you bothering to do a full shutdown before backups? Are you doing backups at all...
If you're using the AIO image, backup/restore can handled for you, so no need to worry about the manual steps involved. Or if you're using a VM, a backup can take the form of full system snapshots, so also no need to understand how data are stored. Granted it's always helpful to know what your running, but not necessarily requisite, even for backups.
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.
I found this way funnier then I think you meant it.... PVC wasn't persistent volume claim was it?
If you need to fix something, you should know what it is.
The rule of internet polls is that the funniest answer is always over-represented.
*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 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.
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)
Where's the option for "what's a database?"
If some of them are users rather than admins, it makes sense and maybe it's a good sign that they don't have to know in order to use the service.
Users is the right word here, not admin, not sysadmin, not owner. Docker pull docker up users that’s it
Also just users. No docker or anything, just using the system someone else setup for them.
NextCloud is used everywhere, also in commercial use.
I mean.. I set it up many many years ago... Without looking it up I can also just guess.
Honestly I think if there is a hope for greater detach from "The Cloud" more broadly, it's a testament to nextcloud that folks that don't even know enough to know what DB they are running are able to run a server, and host things well enough to consider themselves users.
shhh
This statement brought was to you by someone that set up nextcloud and had no clue what DB it was using.
I don't even know myself because I installed it via YunoHost
Same here with Freedombox.
A Freedombox user in the wild!! I've been following the project since 2011 but I never thought it really achieved its potential. How do you use yours, and how do you find it?
I'm not a very experienced user, but I'm happy with it. I have mainly a static blog, an almost unused Nextcloud, a Matrix server (down since yesterday, I don't know why) and my calendar. It works quite well!
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.
Well it does depend on your exact use case, but using a proper database is usually the better option for production. Now if this is just some little service you made for yourself use whatever you want.
SQLite is a proper database. Realistically you’ll never exhaust its 278tb storage limits, it’s thoroughly battle tested, and it’s dead easy to backup.
I doubt nextcloud is running enough parallel db writes for this to actually matter — and if it is WAL mode is still probably good enough.
Once you have multiple software clients running then you will need a client server dbms like Postgres. For most home or group installations, this should not be an issue.
Since Nextcloud stores your actually data on the disk, it doesn’t actually matter all that much tbh
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.
What's a computer ?
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 :)
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.
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 can think of few things more boring than databases. I just want my files synced and stored.
And 46% have no idea what a database is.
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 don’t think it matters
You could deploy a container and not know what DB is used
TIL that NextCloud can use an external database.
Are you still using sqlite?
I did know when I set it up, but I can't remember right now. I can easily go check though.
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
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.
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
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.
top 89 comments