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.
this post was submitted on 04 Sep 2025
468 points (97.0% liked)
Selfhosted
51259 readers
482 users here now
A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.
Rules:
-
Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
-
No spam posting.
-
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
-
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
-
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
-
No trolling.
Resources:
- selfh.st Newsletter and index of selfhosted software and apps
- awesome-selfhosted software
- awesome-sysadmin resources
- Self-Hosted Podcast from Jupiter Broadcasting
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
founded 2 years ago
MODERATORS
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?
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
load more comments
(1 replies)
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%?
load more comments
(1 replies)
MariaDB, only know that because I tried to install ampache (got it to work, hated 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
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