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?
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