Selfhosted

63,656 readers

5,220 active

340 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

Be civil.
No spam.
Posts are to be related to self-hosting.
Don't duplicate the full text of your blog or readme if you're providing a link.
Submission headline should match the article title.
No trolling.
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.
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:

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 3 years ago

moderation log

moderators

curbstickle@anarchist.nexus

curbstickle_lw@lemmy.world

18% of people running Nextcloud don't know what database they are using (programming.dev)

submitted 1 year ago by otto@programming.dev to c/selfhosted@lemmy.world

151 comments fedilink hide all child comments

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?

you are viewing a single comment's thread
view the rest of the comments

[–] chickenf622@sh.itjust.works 3 points 1 year ago (2 children)

Well 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.

permalink

fedilink

source

parent

hideshow 2 child comments

[–] panda_abyss@lemmy.ca 11 points 1 year ago (1 child)

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.