The Unix Way, everybody!
The Unix Way, everybody!
72 comments
-
If file systems are databases, then does that mean storing a sqlite db on a HDD is database inception?
-
@slazer2au Yes!
-
-
@linuxmemes Wow, that worked!
-
How do you post from mastodon to lemmy?
-
@mogoh I just mentioned the group and it worked!
The way it's supposed to be!
I'm so happy for this omfgrotflolcopter
-
Federation.
Wait till you get a comment from threads. I've only had it happen once and it made me feel dirty.
-
@mogoh AFAIK, I should mention @linuxmemes handle to make the comment visible inside the original Lemmy thread.
@drq
-
-
It does!
-
@30p87 Okay, looks like we finally have actual groups in Fedi that are compatible across the board.
I've been waiting for this for so long, I've almost given up all hope.
-
-
-
-
@drq what worked
-
@th3rdsergeevich@udongein.xyz
@drq @linuxmemes you forgor to mention linuxmemes
-
-
-
everything is a file including a filesystem
including databases
-
git repo is blockchain
-
For example, a directory full of spreadsheets.
Somewhere, a sysadmin is pulling his hair out
-
Tbh still preferred to that asshat who rolls out an MS Access "app"
-
*starts rocking back and forth in chair
-
-
or CSV files
-
-
and anuses are vaginas, as long as you treat them as one.
-
bussy
-
As a man of science I prefer to test every theory.
-
the anus isnt self lubricating :(
-
https://my.clevelandclinic.org/health/body/24784-anus-function
Muscles, nerves and mucous membranes in your anus
It is though...
-
It can be if you're lactose intolerant.
-
-
-
Didn't someone actually try making SQL as a filesystem and it ended up being something like 50 times slower than ZFS after they applied a ton of optimizations?
Not as a serious project, but more like a joke to see what would actually happen.
-
You're right! Ill just store all this data as static json files in a directory then
-
And files are streams. 🎵 Islands in the stream. 🎵
-
🎵 That is what we awk 🎵
-
-
They’re more like blob storage.
-
Blob storage usually uses a FS back end so it’s more like blob storage is like a file system
-
-
But they are not DBMS
-
That's less the Unix way and more the BeOS way.
-
Just fucking putting data into json files in a folder is so much easier than databases. Sure, databases are faster and give you access to powerful SQL queries. But if you're just making something small and simple, you don't need those things. Save yourself the hassle and just use the filesystem.
Or use minio/s3, which can either be the best or the worst of both worlds depending on your usecase.
-
The trouble is, filesystems don't have ACID. The first time you have a power loss during a write, your data will get corrupted.
-
Hmm that's a valid criticism, thanks for pointing it out
-
-
Duckdb can query them with SQL like they are in a database. Csv, tsv, parquet also. You can even connect to and query postures and cloud storage also
-
-
-
@mugdad1 Trick is, I'm not on Lemmy.
-
-
Filesystem-as-a-db is why MongoDB is webscale. You just turn it on and it scales right up.
-
Every Homestuck fan already knows this.
-
@RizzRustbolt What's your fetch modus, warrior?
-
-
I love how pacman/libalpm database is just directories with tiny little files, and it’s faster in resolving dependencies than mostly anything else
-
The list of reasons filesystems are not databases is a database.
-
Honestly that's basically what CephFS is
-
@possiblylinux127 Or BeFS
-
BeFS doesn't run on top of a data store. CephFS runs on RADOS.
-
-
-
And the worst FAT32
-
@drq Come on, that can't be your F I R S T post.
@linuxmemes-
@th3rdsergeevich It is my first op-post on lemmy, that's right.
-
-
Behold! I present to you: Database as Filesystem
-
🤯😵
-
Mine's more of a databivouac.
-
I don't know why this one was such a good laugh, but great first post.
-
@someguy Thank you!
-
-
And all code is data too, and all processes are data transformers
-
Well, that's ok, you are welcome.
-
@pics
-
Does not work
-
-
@drq@mastodon.ml Second post?
@linuxmemes@lemmy.world -
72 comments