Submitted 20 hours 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?
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 did know when I set it up, but I can’t remember right now. I can easily go check though.
Same. I’m glad I don’t have to think about databases usually.
Mine is managed hosted so I don’t know.
Are people here trying to “I run arch btw” database services.
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.
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.
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...
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
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.
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
…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.
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
NENathaniel@lemmy.ca 17 hours ago
Yes that’s me. I have no idea where my Nextcloud uses