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.
Comment on 18% of people running Nextcloud don't know what database they are using
Railcar8095@lemmy.world 3 days ago
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.
4am@lemmy.zip 2 days ago
Railcar8095@lemmy.world 2 days ago
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
SomethingBurger@jlai.lu 2 days ago
SQLite is fine for small amounts of data and very few users. The bottleneck with Nextcloud is almost never the database.