Submitted 2 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?
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.
I think that’s really beautiful.
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.
Are people here trying to “I run arch btw” database services.
Mine is managed hosted so I don’t know.
East or West, SQLite is the best.
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.
Should’ve specifically asked the operators/hosters if they need a better answer. But this has more engagement so
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.
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
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.
They really push you to install the aio container so it’s not surprising to me.
Not sure I understand… Can the type of database be customised during nextcloud installation? If not, then more than 37% gave a wrong answer, which is worse than the 18%?
Yes, all three are supported configurations. Technically all four, since “I don’t know” is apparently a completely valid and functional configuration too.
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.
…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.
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...
The more shocking is that one guy who KNOWS it’s sqlite, but ain’t afraid to admit it!
What’s a Next Cloud, what came before it? /s
MariaDB, only know that because I tried to install ampache (got it to work, hated it).
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.
SQLite has made huge performance improvements in the last like 3-5 years.
I wouldn’t spin up an enterprise NextCloud with it but for a home NAS serving up to maybe a dozen people it’s more than enough.
Maybe it’s that. I haven’t truly used it in 7-8 years… Both next cloud and airflow were horrible with sqlite back then, even for single user small instances.
Will have to try again
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
Where’s the MySQL option? Some of my servers are running MySQL instead of MariaDB because it allowed binding to multiple IP addresses (although I think Maria has implemented this now), and some query plan optimizations were implemented in MySQL but not MariaDB.
Honestly I’m not sure I’d know Immich used Postgres if it didn’t outright say so
lka1988@lemmy.dbzer0.com 2 months ago
I did know when I set it up, but I can’t remember right now. I can easily go check though.
tofu@lemmy.nocturnal.garden 2 months ago
Same. I’m glad I don’t have to think about databases usually.