18% of people running Nextcloud don't know what database they are using
from otto@programming.dev to selfhosted@lemmy.world on 04 Sep 17:39
https://programming.dev/post/36876896

Nextcloud asked in a poll at mastodon.social/…/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?

#selfhosted

threaded - newest

paraphrand@lemmy.world on 04 Sep 17:46 next collapse

Every person using a computer should know what their filesystem is and what database they are using. Otherwise they are fools.

Can you believe kids don’t know what NTFS or APFS are these days?! Stupid iPad babies.

paper_moon@lemmy.world on 04 Sep 17:49 next collapse

Haha at some point it did matter to regular folks though. I remember in Junior high when I would try to pirate games or software on Windows, I learned the big difference between fat32 and the new filesystem Microsoft released, NTFS because I couldn’t download files larger than 4GB on fat32.

undefined@lemmy.hogru.ch on 04 Sep 17:55 next collapse

It’s important if you’re using flash drives across platforms though that’s pretty rare these days too. My wife has run into this problem by formatting as ExFAT (GUID partition table) when print shops’ terrible machines only support FAT32 and/or MBR partition tables.

Thankfully macOS at home understands ExFAT otherwise those formatted drives from her Windows work computer wouldn’t even work.

squaresinger@lemmy.world on 04 Sep 18:03 next collapse

At that point, were you regular folks though?

paper_moon@lemmy.world on 04 Sep 18:09 next collapse

True, I guess not. But piracy was big at that age group because we were kids who didn’t have our own money, so if our parents didn’t buy the games we wanted, people would try to download them instead. So I fell into learning this detail by necesssity instead of out of pure curiosity or desire to learn more about the computer. I wanted to download Neverwinter Nights or whatever game, and fat32 was standing in my way, haha

cmnybo@discuss.tchncs.de on 04 Sep 19:05 collapse

FAT32 is still a very common filesystem for flash drives and memory cards because it works on everything. Lots of people are likely to run into the 4GB file size limit.

Ledivin@lemmy.world on 04 Sep 18:25 next collapse

I still have a FAT32 external drive that this (very) rarely still bites me 😫 there’s nothing important on it, so I’ve been lazy

lemming741@lemmy.world on 04 Sep 19:05 next collapse
JackbyDev@programming.dev on 06 Sep 00:07 collapse

I remember having to open “.zip.1” files lol. From the split zips.

tfm@piefed.europe.pub on 04 Sep 18:01 next collapse

<img alt="" src="https://piefed.europe.pub/static/media/posts/gh/8D/gh8DXKAhGZi7fZL.png">

panda_abyss@lemmy.ca on 04 Sep 19:56 collapse

That kid is never going to figure out if they downloaded the assignment pdf to “Downloads (iPad)” or “Downloads (iCloud)”

chickenf622@sh.itjust.works on 04 Sep 18:15 next collapse

Wait is APFS a new file system than NTFS? Guess I’m too busy on my Tiktoks and Nintendos to keep up to date

grte@lemmy.ca on 04 Sep 18:38 next collapse

Apple file system

chickenf622@sh.itjust.works on 04 Sep 20:47 next collapse

Ah that would explain why I didn’t know. I have next to no experience with Apple devices.

Engywuck@lemmy.zip on 04 Sep 21:00 collapse

Ewww…

paraphrand@lemmy.world on 04 Sep 23:33 collapse

Look into it, it’s pretty good.

And Apple updated hundreds of millions of devices to it from an old file system without losing any data. Imagine Microsoft pulling off such a migration. It was silently done in the background with a normal OS update. Really impressive.

lightnegative@lemmy.world on 06 Sep 20:52 collapse

No, it’s garbage because of its approach to case sensitivity.

It’s case insensitive by default (which is a WTF in itself and encourages the same laziness Windows users thrive on with NTFS) but it also has a case sensitive mode.

Except the case sensitive mode is almost entirely useless because of the amount of apps it breaks that assume the default case-insensitive mode. It also means that you as a programmer have to add extra crap to your file handling code for case insensitive string comparisons if you want to support both modes

Mordikan@kbin.earth on 04 Sep 18:40 next collapse

Damn kids with your twitternets and me mes.

BlackVenom@lemmy.world on 04 Sep 22:54 next collapse

It’s used on popular toys and consumer gadgets. Most well to do tech nerds don’t bother with such riff raff either.

Eheran@lemmy.world on 04 Sep 22:56 collapse

Armor piercing fin stabilized.

ominouslemon@sh.itjust.works on 04 Sep 18:25 next collapse

Kids don’t event know the folder struture of their Home directory, so why would they know what a File System is? Lol

princessnorah@lemmy.blahaj.zone on 04 Sep 18:58 next collapse

Holy Poe’s Law…

DaveX64@lemmy.ca on 04 Sep 19:59 collapse

Sir, this is a Wendy’s :)

Horta@discuss.tchncs.de on 04 Sep 17:50 next collapse

If some of them are users rather than admins, it makes sense and maybe it’s a good sign that they don’t have to know in order to use the service.

slazer2au@lemmy.world on 04 Sep 17:53 next collapse

Honestly, does it matter to a regular user?
There will be some that do matter, if I were to run NC I would use Lite because why throw the data to another process just to write it to a disk when I only have a single node.

chickenf622@sh.itjust.works on 04 Sep 18:17 collapse

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.

panda_abyss@lemmy.ca on 04 Sep 20:05 collapse

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 on 07 Sep 10:34 collapse

Even if you have multiple clients (most have a phone + laptop) WAL would be able to handle that easily, have you seen the benchmarks?

SparroHawc@lemmy.zip on 04 Sep 17:56 next collapse

If you’re running it in a prebuilt container, as long as it works it shouldn’t matter and you don’t need to care.

Of course, when your database gets corrupted after Nextcloud updates because you had an app running that isn’t supported in the new version, it will suddenly matter a lot.

troed@fedia.io on 04 Sep 18:06 next collapse

Will Nextcloud run apps not marked as compatible with that version?

SomethingBurger@jlai.lu on 04 Sep 22:44 next collapse

No.

Getting6409@piefed.ee on 05 Sep 07:57 next collapse

You can specify the behavior in a few places, gui, occ command, config.php. By default no, but if you have an app you want to force in regardless of the version compatibility you can make it so
https://help.nextcloud.com/t/help-what-is-app-install-overwrite-for/71523

matzler@lemmy.ml on 05 Sep 19:10 collapse

Bugs still happen. Just did with the most recent version and the polls app and mysql

Pechente@feddit.org on 04 Sep 18:58 next collapse

I‘m using a hosted Nextcloud instance from Hetzner and I have no idea what this is running on either. There’s a significant number of people who didn’t set up their Nextcloud instance, so people not knowing what it’s running on isn’t too surprising.

med@sh.itjust.works on 06 Sep 00:19 collapse

And if you don’t know what database you’re running, how are you backing it up?

If you don’t know what database you’re running, are you bothering to do a full shutdown before backups? Are you doing backups at all…

SparroHawc@lemmy.zip on 06 Sep 05:16 next collapse

Exactly. It’s not important … until it is. :D

kossa@feddit.org on 08 Sep 15:51 next collapse

The poll did not ask specifically for self-hosted instances. You know you can buy hosted Nextclouds where the service provider hopefully cares for that stuff? So customers wouldn’t know which database they use. I don’t know which database my mail provider uses ¯\_(ツ)_/¯

med@sh.itjust.works on 08 Sep 17:36 collapse

Fair enough, I did assume the target audience was selfhosters based on the question.

As for provider backups - well, you’d hope. But M$ doesn’t do user available backups, so I’d be surprised if that was bundled by the average SaaS provider.

lucas@startrek.website on 09 Sep 07:44 collapse

If you’re using the AIO image, backup/restore can handled for you, so no need to worry about the manual steps involved. Or if you’re using a VM, a backup can take the form of full system snapshots, so also no need to understand how data are stored. Granted it’s always helpful to know what your running, but not necessarily requisite, even for backups.

idefix@sh.itjust.works on 04 Sep 17:56 next collapse

I don’t even know myself because I installed it via YunoHost

zloubida@sh.itjust.works on 04 Sep 18:27 collapse

Same here with Freedombox.

drspod@lemmy.ml on 04 Sep 19:12 collapse

A Freedombox user in the wild!! I’ve been following the project since 2011 but I never thought it really achieved its potential. How do you use yours, and how do you find it?

zloubida@sh.itjust.works on 05 Sep 14:01 collapse

I’m not a very experienced user, but I’m happy with it. I have mainly a static blog, an almost unused Nextcloud, a Matrix server (down since yesterday, I don’t know why) and my calendar. It works quite well!

drspod@lemmy.ml on 05 Sep 14:41 collapse

That’s good to hear, thanks for the reply!

m33@lemmy.zip on 04 Sep 18:04 next collapse

Users is the right word here, not admin, not sysadmin, not owner. Docker pull docker up users that’s it

themurphy@lemmy.ml on 04 Sep 18:23 next collapse

Also just users. No docker or anything, just using the system someone else setup for them.

NextCloud is used everywhere, also in commercial use.

m33@lemmy.zip on 04 Sep 19:16 collapse

I can’t believe they asked end users, the question is sent over the fediverse, not X or Bsky…

Or else they would have received tons of « it’s missing my Nextcloud runs on Samsung S24 » comments

atzanteol@sh.itjust.works on 05 Sep 13:58 collapse

Read the comments. Self hosters are little more than users anyway.

cygnus@lemmy.ca on 04 Sep 18:14 next collapse

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

Rentlar@lemmy.ca on 04 Sep 18:20 collapse

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.

BeatTakeshi@lemmy.world on 04 Sep 18:22 next collapse

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%?

cecilkorik@lemmy.ca on 04 Sep 19:06 collapse

Yes, all three are supported configurations. Technically all four, since “I don’t know” is apparently a completely valid and functional configuration too.

Ooops@feddit.org on 04 Sep 18:32 next collapse

Isn’t that the whole point of containerised solutions? Having some pre-setup, auto-updating solution with very little requirement to dive into the details like what your database is and which dependencies you need to manage…

dan@upvote.au on 04 Sep 18:49 collapse

You still need to know what database system is being used in order to make backups of the database. You can’t just snapshot or backup the data directory while a database is running, because you might end up with an inconsistent state that won’t restore properly. You need to either stop the DB before doing the backup, or use the relevant DB-specific tools to perform a backup.

Ooops@feddit.org on 04 Sep 19:49 next collapse

So one in five doesn’t do proper backups. That’s much better than expected… 😅

dan@upvote.au on 04 Sep 21:55 collapse

I’d say 9/10 aren’t doing proper backups given most people don’t actually do DR runs and verify whether they can fully recover from their backups. If you don’t test your backups, you don’t have backups!

monogram@feddit.nl on 07 Sep 10:30 collapse

90% is a bit low if the requirement is a full backup of nextcloud with database that is easily restorable.

If they do backups, most just copy the important stuff manually to an external hard drive.

onslaught545@lemmy.zip on 04 Sep 20:14 collapse

Most of my containerized solutions do that for me.

dan@upvote.au on 04 Sep 21:54 collapse

Which containers do automatic DB backups? Normally the database is a separate container, unless the app is using SQLite. Is there a MySQL or PostgreSQL container that does automated backups?

LainTrain@lemmy.dbzer0.com on 04 Sep 18:41 next collapse

Honestly I’m not sure I’d know Immich used Postgres if it didn’t outright say so

lka1988@lemmy.dbzer0.com on 04 Sep 18:47 next collapse

I did know when I set it up, but I can’t remember right now. I can easily go check though.

tofu@lemmy.nocturnal.garden on 04 Sep 19:45 collapse

Same. I’m glad I don’t have to think about databases usually.

dan@upvote.au on 04 Sep 18:52 next collapse

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.

brewery@feddit.uk on 04 Sep 18:53 next collapse

They really push you to install the aio container so it’s not surprising to me.

i_stole_ur_taco@lemmy.ca on 04 Sep 19:03 next collapse

That’s how I’d answer if I set something up years ago and it was stable and never required me to come tinker with it.

mereo@piefed.ca on 04 Sep 19:06 next collapse

There could be multiple factors. For example, I have a Nextcloud instance that is fully managed by Hetzner, and I didn't bother to find out what database it uses...

EncryptKeeper@lemmy.world on 04 Sep 19:15 next collapse

Since Nextcloud stores your actually data on the disk, it doesn’t actually matter all that much tbh

electric_nan@lemmy.ml on 04 Sep 19:20 next collapse

I can think of few things more boring than databases. I just want my files synced and stored.

sfjvvssss@lemmy.world on 04 Sep 20:24 next collapse

Mine is managed hosted so I don’t know.

NENathaniel@lemmy.ca on 04 Sep 20:30 next collapse

Yes that’s me. I have no idea what my Nextcloud uses

tazeycrazy@feddit.uk on 04 Sep 20:42 next collapse

Are people here trying to “I run arch btw” database services.

Postimo@lemmy.zip on 04 Sep 20:58 next collapse

Honestly I think if there is a hope for greater detach from “The Cloud” more broadly, it’s a testament to nextcloud that folks that don’t even know enough to know what DB they are running are able to run a server, and host things well enough to consider themselves users.

shhh

This statement brought was to you by someone that set up nextcloud and had no clue what DB it was using.

zr0@lemmy.dbzer0.com on 04 Sep 21:09 next collapse

And 46% have no idea what a database is.

metaStatic@kbin.earth on 04 Sep 21:37 collapse

it's a spreadsheet right?

Ajen@sh.itjust.works on 04 Sep 21:17 next collapse

I write software for a living, and have worked with all 3 database options in the past. I don’t know what DB backend my nextcloud server is using, nor do I care.

dustyData@lemmy.world on 04 Sep 21:24 collapse

Yeah, that is the kind of concern for the service developer or a very opinionated sys admin. For self-hosting, few people will reach the workload where such a decision has any material or measurable impact.

u_tamtam@programming.dev on 04 Sep 21:34 next collapse

Self hosting doesn’t mean “being wasteful and letting containers duplicate services”. I want to know which DB application X is using, so I pool it for applications Y and Z.

Ajen@sh.itjust.works on 04 Sep 22:00 next collapse

For most applications the overhead of running a second DB server is negligible.

absentbird@lemmy.world on 04 Sep 23:07 next collapse

And if it’s SQLite (which I believe is the default) it’s really just reading and writing a file on the file system.

u_tamtam@programming.dev on 05 Sep 19:35 collapse

I disagree. You are just entertaining the idea that servers must always and forever be oversized, that’s the definition of wasteful (and environmentally irresponsible). Unless you are firing-up and throwing-away services constantly, nothing justifies this and sparing the relatively low effort it is to deploy your infrastructure knowingly.

Ajen@sh.itjust.works on 05 Sep 19:44 collapse

Do you have the data to back that up? Have you measured how much of an impact on system load and power consumption having 2 separate DB processes has?

Roughly the same amount of work is being done by the CPU if you split your DBs between 2 servers or just use one. There might be a slight increase in memory usage, but that would only matter in a few niche applications and wouldn’t affect environmental impact.

u_tamtam@programming.dev on 06 Sep 22:17 collapse

Do you have the data to back that up?

I mean, you are the one making the exceptional claim that unnecessarily running multiple instances of programs on a device with finite resources has no practical adverse effect. Of course, the effects can be more or less drastic depending on the many variables at play (hardware, software, memory pressure, thread starvation, cache misses, …) and can indeed be negligible in some lucky circumstances. The point is that you don’t call that shot, and especially not by burying your head in the sand and pretending it’s never gonna be a problem.

Effective use of computing resources requires tuning. Introduction of a new service creates imbalance. Ensuring that the server performs nominally and predictably for all intended services is a balancing act and a sysadmin’s job. Services whose deployment settings are set by someone with no prior knowledge of the deployment constraints can’t be trusted to do a good job at it (that’s the nature of the physical world we live in, not my opinion), and promoting this attitude promote the kind of wasteful and irresponsible computing I was on about.

Now, I’ll give you the link to this basic helper for tuning a PostgreSQL server: pgtune.leopard.in.ua
Will you tell me what are the correct inputs for my homelab (I won’t tell you the hardware, the set-up, the other services running on it, the state of the system, etc)?
And later, when you will distribute your successful container to millions of users, what will you respond to the angry ones that will complain that your software is slow, to no fault of your coding, because they happen to pile up multiple DBs, web servers, application servers, reverse proxies, … on their banana SoCs?

Ajen@sh.itjust.works on 06 Sep 22:38 collapse

I’m saying this based on real world experience: after a certain point you start to see deminishing returns when optimizing a system, and you’re better off focusing your efforts elsewhere. For most applications, customizing containerized services to share databases is far past that point.

u_tamtam@programming.dev on 07 Sep 14:56 collapse

I’m saying this based on real world experience

And do you think I would spend my time engaging if that wasn’t from my own very “real world experience” of lessons learned the hard way?

Bringing-up “diminishing returns” as if this was an optimisation game also doesn’t do this justice. Take the typical “household FOSS package” with software names often brought up in here: a nextcloud instance, a photo-sharing service like immich, private instant messaging, a software forge, a subsonic-compatible audio/video streaming server, a couple php websites like wallabag and RSS aggregators.

An Intel Atom CPU and 4GB of RAM is plenty sufficient for all that, and will cost you single digit USD a month, granted you put the (one-time) effort to tune and balance those services. Would you run all the above from upstream’s docker files, I can guarantee you that you would deem this (perfectly fine otherwise) server underpowered for the task at hand (and would probably go for a 10th gen or so Intel Core CPU, quadruple the RAM and 3-6× the energy cost in the process).

And that’s the point I’m making here: a self-hosting community of tinkerers should (ideally) know better, for the ethics’ sake of keeping the process environmentally friendly, and not wasting other people’s money.

Ajen@sh.itjust.works on 07 Sep 16:26 collapse

You seem to be obsessed with optimising one resource at the expense of others. Time is a limited resource, and even if it only takes 5 minutes to configure all of your containers to share a single db backend (it will take longer than that even if you just have 2), you’re only going to save a few MB of RAM. And since RAM costs roughly $2.5/GB (0.25 cents/MB) your time would have to be worth very little for this to be worthwhile.

On the other hand, if you’re doing it to learn more about computers then it might be worthwhile. This is a community of hobbiests, after all…

u_tamtam@programming.dev on 07 Sep 18:57 collapse

You seem to be obsessed with optimising one resource at the expense of others.

If you want to push it and paint me as obsessed about something, then let it be this: providing this community with on-topic and reasonable advice

you’re only going to save a few MB of RAM.

This is false, and you should read once again my previous message illustrating why: on a decent “self-host”-friendly machine, the same software may work very well, or not at all, depending on whether the user would engage with very basic configuration. This goes beyond RAM (memory isn’t the sole shared resource), and I’m adamant that the alternative (which was “pretending that the problem doesn’t exist” turned into “throwing money at the problem”) is unreasonable.

On the other hand, if you’re doing it to learn more about computers then it might be worthwhile. This is a community of hobbiests, after all…

Or more importantly: the extent to which you can self-host out of sheer luck and ignorance like you suggest is very limited. If you don’t want to engage with a minimum amount of configuration, you might bump into security issues (a much broader and complex subject) long before any of the above has a material impact.

Ajen@sh.itjust.works on 09 Sep 02:14 collapse

Besides RAM, what resources do for think you’re saving? Not CPU cycles or IO ops, because you’re processing the same amount of DB queries either way. Not power consumption, since that isn’t affected by RAM utilization. Maybe disc space? But that’s even cheaper than RAM.

Or more importantly: the extent to which you can self-host out of sheer luck and ignorance like you suggest is very limited. If you don’t want to engage with a minimum amount of configuration, you might bump into security issues (a much broader and complex subject) long before any of the above has a material impact.

You’re mischaracterizing what I said. My point is that running multiple DB processes on a server isn’t going to have a significant impact on system load, if all other factor are kept constant.

tburkhol@lemmy.world on 05 Sep 10:01 collapse

This is one of my pet peeves with containerized services, like why would I want to run three or four instances of mariadb? I get it, from the perspective of the packagers, who want a ‘just works’ solution to distribute, but if I’m trying to run simple services on a 4 GB RPi or a 2 GB VPS, then replicating dbs makes a difference. It took a while, but I did, eventually, get those dockers configured to use a single db backend, but I feel like that completely negated the ‘easy to set up and maintain’ rationale for containers.

u_tamtam@programming.dev on 05 Sep 13:00 collapse

Precisely what pre-devops sysadmins were saying when containers were becoming trendy. You are just pushing the complexity elsewhere, and creating novel classes of problems for yourself (keeping your BoM in control and minimal is one of many others that got thrown away)

stardreamer@lemmy.blahaj.zone on 04 Sep 22:00 collapse

Exactly. Unless you are actively doing maintenance, there is no need to remember what DB you are using. It took me 3 minutes just to remember my nextcloud setup since it’s fully automated.

It’s the whole point of using tiered services. You look at stuff at the layer you are on. Do you also worry about your wifi link-level retransmissions when you are running curl?

IncogCyberspaceUser@lemmy.world on 05 Sep 08:32 collapse

Sorry for the newbie question, but how is your nextcloud setup automated? Is that like a compose/yaml file?

stardreamer@lemmy.blahaj.zone on 05 Sep 23:07 collapse

stares at 300 line shell script+ansible mess that updates/sets up Forgejo, Nextcloud, ghostcms

“Yes… It’s automated”

nshibj@lemmy.world on 04 Sep 21:42 next collapse

*18% of the people who answered a poll on Mastodon

TMP_NKcYUEoM7kXg4qYe@lemmy.world on 08 Sep 17:22 collapse

It’s funny that the headline frames it as “a big number” when in reality majority of users don’t know what database they’re using and probably don’t even know what a database is. Such polls aren’t useless but you always get skewed results towards the more technical population. They would have to create a poll inside the nextcloud webapp to get more balanced results.

Railcar8095@lemmy.world on 04 Sep 22:19 next collapse

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.

SomethingBurger@jlai.lu on 04 Sep 22:43 next collapse

SQLite is fine for small amounts of data and very few users. The bottleneck with Nextcloud is almost never the database.

4am@lemmy.zip on 04 Sep 23:31 collapse

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 on 05 Sep 07:38 collapse

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

lambalicious@lemmy.sdf.org on 04 Sep 22:29 next collapse

…How come so few people are using SQLite?

kilgore_trout@feddit.it on 04 Sep 22:32 next collapse

Probably also most of those who don’t know. SQLite is the default option if you don’t set up a database server.

SomethingBurger@jlai.lu on 04 Sep 22:42 collapse

Those who don’t know may be using Nextcloud AIO, which is bundled with Postgres.

sugar_in_your_tea@sh.itjust.works on 05 Sep 18:51 collapse

Idk, I explicitly set up Postgres, which took extra work since the default is SQLite. I use Postgres for my day job, so it makes sense to me to keep everything the same.

lambalicious@lemmy.sdf.org on 06 Sep 19:08 collapse

That’s quite senseful yes. In the cases where I want to host somewhere that already has a Postgres service going, I just up and use that.

Zorque@lemmy.world on 04 Sep 22:36 next collapse

The rule of internet polls is that the funniest answer is always over-represented.

LiveLM@lemmy.zip on 04 Sep 23:12 next collapse

Who cares.
I’m only on MariaDB because I have brain worms, I have so little data on there SQLite would have been fine. 🪱 🪱 🪱

surph_ninja@lemmy.world on 04 Sep 23:16 next collapse

Exactly. Who gives a shit?

I mean… I could recite the exact setup of mine in detail, but I’d probably be happier if my brain matter was dedicated to something else. Do not shame the ignorant. Envy them.

4am@lemmy.zip on 04 Sep 23:29 next collapse

SQLite actually has incredible performance these days. But I get your point :)

sugar_in_your_tea@sh.itjust.works on 05 Sep 18:50 collapse

I use Postgres, because MySQL touched me inappropriately as a kid and MariaDB is too similar. Oh, and also because it’s what I use at work.

Dagnet@lemmy.world on 04 Sep 23:20 next collapse

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

pigup@lemmy.world on 04 Sep 23:21 next collapse

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

4am@lemmy.zip on 04 Sep 23:26 next collapse

You can install NextCloud with snap.

phx@lemmy.ca on 04 Sep 23:40 collapse

Yeah, and after having dealt with the “I missed a few updates and then the last one put my files out of sync with my schema” Docker issues, I’m very much happy to use the snap. Been on that a couple years and it’s been quite solid, even if I did have to install snapd on my Debian base for it

roofuskit@lemmy.world on 05 Sep 00:34 next collapse

That’s because they push the all in one container.

eager_eagle@lemmy.world on 05 Sep 00:59 next collapse

I also have no idea if my place has PVC or galvanized steel plumbing; or its designed electrical load. Why should users care about the DBMS.

Sprocketfree@sh.itjust.works on 05 Sep 02:12 next collapse

I found this way funnier then I think you meant it… PVC wasn’t persistent volume claim was it?

ripcord@lemmy.world on 05 Sep 05:12 collapse

Unless he installed kubernetes pipes, no.

sugar_in_your_tea@sh.itjust.works on 05 Sep 18:48 collapse

If you need to fix something, you should know what it is.

x00z@lemmy.world on 06 Sep 08:16 collapse

I’ll get that info as soon as something breaks, I guess.

dude@lemmings.world on 05 Sep 01:02 next collapse

I’ve made a choice a while ago while deploying Nextcloud. Now I don’t care, as I trust myself that I have opted for something reasonable which was hopefully not SQLite

Electricd@lemmybefree.net on 05 Sep 07:31 collapse

why the hate for SQLite?

Valmond@lemmy.world on 05 Sep 08:54 collapse

SQLite is awesome, but of course not for every project.

fodor@lemmy.zip on 05 Sep 02:37 next collapse

Well that’s kind of misleading, right? If they didn’t set one up, then it’s probably SQLite. But if they did set one up, that was years ago, and who cares what it is, if it’s working.

cryptix@discuss.tchncs.de on 05 Sep 06:39 next collapse

My instance did required me to fix some db issue after an update(it still works but the fix was recommended*). So I knew I am using mariadb. Its not super smooth sailing.

Strit@lemmy.linuxuserspace.show on 05 Sep 06:44 next collapse

People don’t care and/or haven’t looked at the serverinfo page. That actually mentions the type of database in use.

So the “I don’t know” option was probably just the easiest.

Electricd@lemmybefree.net on 05 Sep 07:30 next collapse

I don’t think it matters

You could deploy a container and not know what DB is used

3dcadmin@lemmy.relayeasy.com on 05 Sep 08:45 next collapse

Nextcloud is pushed as an easy to use docker setup these days, heck most people I know who “use” it don’t do much with it at all so what database it is using is gonna be way back in their list of priorities…
Plus the users outweigh the admins surely (as in those that just install then forget)

Zozano@aussie.zone on 05 Sep 09:55 next collapse

Where’s the option for “what’s a database?”

vandsjov@feddit.dk on 05 Sep 10:27 collapse

Agree - I’m sharing files, not databases…

Zozano@aussie.zone on 05 Sep 10:52 collapse

I’m not even sharing files, I’m sharing mp3’s and some zips. Duh.

justme@lemmy.dbzer0.com on 05 Sep 10:03 next collapse

I mean… I set it up many many years ago… Without looking it up I can also just guess.

biofaust@lemmy.world on 05 Sep 10:05 next collapse

That is actually good news. Means that people more likely to be “normies” are adopting an alternative solution.

theshatterstone54@feddit.uk on 05 Sep 12:47 next collapse

I can confirm I’m a newer user (not a normie) to Nextcloud and I don’t know or really care what it uses because it works so I haven’t had to learn what it is or how to debug it.

daniel@federation.network on 06 Sep 22:30 collapse

@biofaust@lemmy.world @otto@programming.dev This also means there are probably a ton of unpatched databases directly connected to an internet facing service lol

biofaust@lemmy.world on 07 Sep 09:51 next collapse

That should be possible to solve even locally by making new versions a requirement,etc., right?

kolorafa@lemmy.world on 08 Sep 06:08 collapse

Not really, they might not know because it is a hosted service like from Hetzner or they did start some prebuild (for example docker-compose) package and most of those have database attached locally without exposing it outside.

daniel@federation.network on 08 Sep 06:59 collapse

@kolorafa@lemmy.world It doesn't really matter if it's directly exposed. If the database is connected to a publicly available service you can feed it malicious data and commands.
Also docker-compose doesn't change that you have to install updates and migrate to new major releases once in a while.

kolorafa@lemmy.world on 08 Sep 13:02 next collapse

What you are talking is about relates to the “unpatched applications” not about database running behind an app, as the difference does matter.

You can have 20years old database and it still be totally secure if the application (which is the guard in that scenario) correctly and very strictly sanitize its data.

So once again, it doesnt matter if I dont know what database is running inside some all-in-one app container, as long as this database is only accesed by the application and application is up-to-date and secure.

From every rules are exceptions, but it almost always boils down to the application not cirrectly sanetizing untrusted data.

daniel@federation.network on 08 Sep 14:11 collapse

@kolorafa@lemmy.world I just don't see the use of discussing extremely theoretical scenarios. Most hacks and privilege escalations are usually a chain of unpatched vulnerabilities. Running an unpatched database with an application on a server that is protected against all zero days is not what the real world looks like, so I don't see why you'd want to make it appear like it wasn't a big deal. A statement like that only lulls people who don't know any better into a false sense of security.

kolorafa@lemmy.world on 10 Sep 18:36 next collapse

In a sense if you gain code execution on the application then you can just read the database credentials and authorize yourself to gain full access to data as those applications dont have any database access rules applied, so having exploitable database or not dont change anything.

But if we are talking about high security levels with complex inner-connected services with many apps connecting/talking to database or exposing database outside as a mistake, then yes, totally agree with you.

I’m not saying that you should use old db, Im just saying that you dont need to knoe what db is used in a scenario where app and database is a pre-packaged bundle, because when you update you update whole package so you update both, you are not in controll of the database used and you dont even need to know, what you need to know and do is to Update the whole bundle ASAP.

In case of Nextcould, if you install it from snap/flatpak or use some bundled all-in-one container then you don’t know what database is used and even if you know, then it could be hard to to do anything about it, as it is the package maintainer responsibility to update it.

But if its docker-conpose with 2 containers one for db, you are fully responsible, but then most likely you will know it is using mysql/postgres because it would be in your face.

Also you can use external services like Hetzner offers, then you know that you are using nextcloud but you dont know what they did decided to use as database backed, you are paying for service! So, its like asking if you knoe which database is used by your lemmy instance that you use.


Long story short: (As a user) if the database is bundled in app in a way it is not accessible from outside and is updated togheter with app or you are paying for it as a service, you as a user not knowing what database is running or even if it is using database at all doesnt matter. Just make sure its up-to-date.

kolorafa@lemmy.world on 10 Sep 18:59 collapse

True, you have a valid point, about outdated version of database running in background, as it does matter when you breach the prevuous layers.

My example was a little overreaching, because it sounded like you personally chosing to run old version is fine. Or like it doesnt matter at all. Which is not true. It just matter way way less in comparison of running old/exploitable part that is exposed directly to internet whout any protection.

kolorafa@lemmy.world on 08 Sep 13:04 collapse

If you can feed the database malicious data and commands then you are dirrectly connected to it or application is not correctly sanetizing the data.

null_dot@lemmy.dbzer0.com on 05 Sep 11:07 next collapse

Theres heaps of hosted nextcloud services. Those users wouldn’t know.

Flamekebab@piefed.social on 05 Sep 12:13 next collapse

I have five users, max, and barely any files. I don't know which one Nextcloud AIO uses and I don't care. There's no wrong answer for such a small deployment. It uses whatever database Nextcloud felt was sensible as the default. They know more about picking the right tool for their requirements than I do.

If I'm building something for myself, then I care.

PixelatedSaturn@lemmy.world on 05 Sep 12:23 next collapse

I think that’s really beautiful.

bent@feddit.dk on 05 Sep 12:52 next collapse

It’s awesome that you don’t have to remember what software you’re using underneath. I looked into it before I installed it, but I’d have to check which one I went with. I also have no idea what graphics card I’m using, which headset I’m using, what brand of eyeglass cleaner I’m using etc. I looked into it at the time, made a choice and promptly forgot about why and filled my brain with other things.

If I remembered which database I was running it means that I’d have enough problems with it that I’d look at it a lot.

non_burglar@lemmy.world on 05 Sep 13:18 next collapse

“18% of car owners don’t know their brake fluid DOT rating.”

stratself@lemdro.id on 05 Sep 14:27 next collapse

Should’ve specifically asked the operators/hosters if they need a better answer. But this has more engagement so

NarrativeBear@lemmy.world on 05 Sep 15:45 next collapse

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

Kernal64@sh.itjust.works on 05 Sep 18:26 next collapse

Before Cloud, obviously.

rmuk@feddit.uk on 05 Sep 18:47 collapse

It’s cloud all the way down.

dysprosium@lemmy.dbzer0.com on 06 Sep 05:46 collapse

And computers all the way up

CrackedLinuxISO@lemmy.dbzer0.com on 05 Sep 18:55 collapse

Serious answer: ownCloud

sixty@sh.itjust.works on 05 Sep 18:27 next collapse

Whatever the docker compose file that I found had

rmuk@feddit.uk on 05 Sep 18:48 next collapse

TIL that NextCloud can use an external database.

Eezyville@sh.itjust.works on 05 Sep 19:22 collapse

Are you still using sqlite?

monogram@feddit.nl on 07 Sep 10:16 collapse

Aren’t you? WAL mode has made SQLite better than the alternatives at this point.

sj_zero@lotide.fbxl.net on 05 Sep 19:13 next collapse

I set up everything I use "bare metal" or at least in an lxc container I directly build and maintain, but most people don't. Makes a lot of sense, to be honest. A lot of prepackaged software uses databases and nobody has to care exactly what it's up to.

rumba@lemmy.zip on 05 Sep 19:14 next collapse

. >18% of people running next cloud are not backing it up.

fodor@lemmy.zip on 06 Sep 05:30 next collapse

This is a fallacious. If you have a very small set of users, what exact data is in the database that you would be upset at losing? Maybe your contacts and your calendar. Which you could back up manually, which might actually be simpler than backing up the database.

rumba@lemmy.zip on 06 Sep 18:13 collapse

I’m sorry, but writing down the data from your organizational program and re-entering it all from scratch is NOT a backup solution.

If you have such scant data to do that, you didn’t need to have nextcould installed in the first place.

Ajen@sh.itjust.works on 06 Sep 22:46 collapse

Where are you getting that from? The fastest and easiest way to back up any server is a full filesystem backup, especially if you’re using something like zfs or btrfs.

rumba@lemmy.zip on 06 Sep 23:53 collapse

I can’t decide if you don’t know what you’re talking about or you’re just trying to troll me.

Ajen@sh.itjust.works on 07 Sep 00:21 collapse

Neither, I’m trying to explain that you don’t need to know the implementation details of the software running on your server to backup the entire thing.

interdimensionalmeme@lemmy.ml on 05 Sep 20:35 next collapse

What’s a computer ?

4k93n2@lemmy.zip on 07 Sep 09:34 collapse

my computer is really slow. where can i download more rams?

interdimensionalmeme@lemmy.ml on 07 Sep 10:39 collapse

Enable hugepage allocation, it will deduplicate memory chunks and save you lotsaram Especially good with an hypervisor desktop

MITM0@lemmy.world on 06 Sep 05:43 next collapse

East or West, SQLite is the best.

deafboy@lemmy.world on 08 Sep 12:58 collapse

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

nibbler@discuss.tchncs.de on 12 Sep 10:21 collapse

sqlite is absolutely awesome

l_isqof@lemmy.world on 12 Sep 17:30 collapse

And there is the single vote…

nibbler@discuss.tchncs.de on 12 Sep 17:32 collapse

😜