Nextcloud asked in a poll at https://mastodon.social/@[email protected]/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?
East or West, SQLite is the best.
You can install NextCloud with
snap.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
Who cares.
I’m only on MariaDB because I have brain worms, I have so little data on there SQLite would have been fine. 🪱 🪱 🪱SQLite actually has incredible performance these days. But I get your point :)
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.
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.
Whatever the docker compose file that I found had
MariaDB, only know that because I tried to install ampache (got it to work, hated it).
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.
That kid is never going to figure out if they downloaded the assignment pdf to “Downloads (iPad)” or “Downloads (iCloud)”
Kids don’t event know the folder struture of their Home directory, so why would they know what a File System is? Lol
Wait is APFS a new file system than NTFS? Guess I’m too busy on my Tiktoks and Nintendos to keep up to date
Damn kids with your twitternets and me mes.
Apple file system
Ewww…
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.
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
Ah that would explain why I didn’t know. I have next to no experience with Apple devices.
Armor piercing fin stabilized.
Holy Poe’s Law…
Sir, this is a Wendy’s :)
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.
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
It’s important if you’re using flash drives although even that’s pretty rare these days. 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 our Macs understand ExFAT otherwise those formatted drives from her Windows work computer wouldn’t even work at home.
At that point, were you regular folks though?
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 nessesssity 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
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.
That is actually good news. Means that people more likely to be “normies” are adopting an alternative solution.
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.
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)I don’t think it matters
You could deploy a container and not know what DB is used
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.
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.
Are people here trying to “I run arch btw” database services.
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.
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.
SQLite is fine for small amounts of data and very few users. The bottleneck with Nextcloud is almost never the database.
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.
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.
If you need to fix something, you should know what it is.
I’ll get that info as soon as something breaks, I guess.
I found this way funnier then I think you meant it… PVC wasn’t persistent volume claim was it?
Unless he installed kubernetes pipes, no.
