this post was submitted on 04 Sep 2025
522 points (97.1% liked)

Selfhosted

62256 readers
556 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:

Detailed Rules Post

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details. Tags [CBH] or [AIP] are required, see the links in Rule 8 for details.

  8. AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post, and find example disclosures here.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

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

(page 3) 50 comments
sorted by: hot top controversial new old
[–] lambalicious@lemmy.sdf.org 3 points 1 year ago (4 children)

...How come so few people are using SQLite?

load more comments (4 replies)
[–] cygnus@lemmy.ca 3 points 1 year ago (1 children)

I use the prebuilt Hetzner one and have no idea either.

[–] Rentlar@lemmy.ca 3 points 1 year ago

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.

[–] pigup@lemmy.world 2 points 1 year ago

MariaDB, only know that because I tried to install ampache (got it to work, hated it).

[–] NarrativeBear@lemmy.world 2 points 1 year ago (2 children)

What's a Next Cloud, what came before it? /s

[–] Kernal64@sh.itjust.works 2 points 1 year ago (2 children)
load more comments (2 replies)
load more comments (1 replies)
[–] deafboy@lemmy.world 2 points 1 year ago (1 children)

The more shocking is that one guy who KNOWS it's sqlite, but ain't afraid to admit it!

[–] nibbler@discuss.tchncs.de 1 points 1 year ago (2 children)

sqlite is absolutely awesome

load more comments (2 replies)
[–] dan@upvote.au 1 points 1 year ago

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.

[–] Dagnet@lemmy.world 1 points 1 year ago

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

[–] Railcar8095@lemmy.world 1 points 1 year ago (2 children)

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 points 1 year ago (1 children)

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.

[–] Railcar8095@lemmy.world 1 points 1 year 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

load more comments (1 replies)
load more comments
view more: ‹ prev next ›