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.
It also makes you re-implement a database, but worse.
Use a JSON file if you just need to serialize/deserialize some data. Use SQLite or a DB server if you need more. Your own code will never match the quality of SQLite.
Sqlite is the best in most cases
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
@pics
Does not work
@[email protected] Second post?
@[email protected]deleted by creator
@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.
Every Homestuck fan already knows this.
@RizzRustbolt What’s your fetch modus, warrior?
“I have a system”. Items are sorted randomly on to the top of “piles”. I can retrieve any item from any pile, but pulling from anywhere except from the top of the pile destroys it.
@RizzRustbolt Associative array here. Aka dictionary. Boring but practical.
And all code is data too, and all processes are data transformers
Honestly that’s basically what CephFS is
@possiblylinux127 Or BeFS
BeFS doesn’t run on top of a data store. CephFS runs on RADOS.
I don’t know why this one was such a good laugh, but great first post.
The list of reasons filesystems are not databases is a database.
And the worst FAT32
Mine’s more of a databivouac.
For example, a directory full of spreadsheets.
Somewhere, a sysadmin is pulling his hair out
or CSV files
Tbh still preferred to that asshat who rolls out an MS Access “app”
But they are not DBMS
welcome to lemmy im new also
@mugdad1 Trick is, I’m not on Lemmy.
wtf how do you mix between lemmy and mastdon i also have account there but i didn’t thought that the content will be here also so please explain
@mugdad1 I don’t mix, I’m on Mastodon. I just mentioned @linuxmemes in op-post et voila! Neat, huh?
That’s what federation is all about.
ok tried mentioning my self their it worked i didn"t knew about that yes i wondered how they are mixed sometimes thanks man
Welcome to the lovely world of the Fediverse! Mastodon and Lemmy, among many other kinds of software, both run on ActivityPub. This means that even if the servers aren’t both running Lemmy or Mastodon, they still speak the same language and can therefore understand the content of each other’s posts (think of it as email, gmail.com can still send and receive mail to outlook.com). Other examples of AcitvityPub software are Misskey, Mbin, Friendica, Pixelfed, Loops, Piefed, PeerTube and many others that I haven’t learned about yet. While they theoretically can all fetch and present posts from each other, due to the choices that each developer makes while designing their software, it might not be very possible to get every post from every software. For example, Mastodon is all about following people, and Lemmy about following communities. Even though Mastodon is able to follow Lemmy communities, Lemmy has (as of writing) no function to follow people (yet).
man i wanna be your frind what an amazing explainition you rock 🥰🥰🥰 i understood everything thanks also i got pixelfiled and mastodon and lemmy and i saw the connection thanks i posted in mastodon can you please go there and see it @[email protected]
If file systems are databases, then does that mean storing a sqlite db on a HDD is database inception?
@slazer2au Yes!
