Comment on 18% of people running Nextcloud don't know what database they are using
chickenf622@sh.itjust.works 1 week agoWell it does depend on your exact use case, but using a proper database is usually the better option for production. Now if this is just some little service you made for yourself use whatever you want.
panda_abyss@lemmy.ca 1 week ago
SQLite is a proper database. Realistically you’ll never exhaust its 278tb storage limits, it’s thoroughly battle tested, and it’s dead easy to backup.
I doubt nextcloud is running enough parallel db writes for this to actually matter — and if it is WAL mode is still probably good enough.
Once you have multiple software clients running then you will need a client server dbms like Postgres. For most home or group installations, this should not be an issue.
monogram@feddit.nl 1 week ago
Even if you have multiple clients (most have a phone + laptop) WAL would be able to handle that easily, have you seen the benchmarks?