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?
The more shocking is that one guy who KNOWS it’s sqlite, but ain’t afraid to admit it!
sqlite is absolutely awesome
And there is the single vote…
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
*18% of the people who answered a poll on Mastodon
I can think of few things more boring than databases. I just want my files synced and stored.
MariaDB, only know that because I tried to install ampache (got it to work, hated it).
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.
shhh
This statement brought was to you by someone that set up nextcloud and had no clue what DB it was using.
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
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?
…How come so few people are using SQLite?
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.
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.
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.
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.
Since Nextcloud stores your actually data on the disk, it doesn’t actually matter all that much tbh
East or West, SQLite is the best.
What’s a computer ?
my computer is really slow. where can i download more rams?
And 46% have no idea what a database is.
it’s a spreadsheet right?