If file systems are databases, then does that mean storing a sqlite db on a HDD is database inception?

@linuxmemes Wow, that worked!

everything is a file including a filesystem*

* including databases

git repo is blockchain

and anuses are vaginas, as long as you treat them as one.

You're right! Ill just store all this data as static json files in a directory then

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.

And files are streams. 🎵 Islands in the stream. 🎵

They’re more like blob storage.

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.

But they are not DBMS

@drq@mastodon.ml @linuxmemes@lemmy.world

welcome to lemmy im new also

Filesystem-as-a-db is why MongoDB is webscale. You just turn it on and it scales right up.

The list of reasons filesystems are not databases is a database.

I love how pacman/libalpm database is just directories with tiny little files, and it’s faster in resolving dependencies than mostly anything else

Every Homestuck fan already knows this.

And the worst FAT32

Honestly that's basically what CephFS is

@drq Come on, that can't be your F I R S T post.
@linuxmemes

Behold! I present to you: Database as Filesystem