If file systems are databases, then does that mean storing a sqlite db on a HDD is database inception?
this post was submitted on 22 Jan 2025
694 points (100.0% liked)
linuxmemes
23939 readers
1943 users here now
Hint: :q!
Sister communities:
Community rules (click to expand)
1. Follow the site-wide rules
- Instance-wide TOS: https://legal.lemmy.world/tos/
- Lemmy code of conduct: https://join-lemmy.org/docs/code_of_conduct.html
2. Be civil
- Understand the difference between a joke and an insult.
- Do not harrass or attack users for any reason. This includes using blanket terms, like "every user of thing".
- Don't get baited into back-and-forth insults. We are not animals.
- Leave remarks of "peasantry" to the PCMR community. If you dislike an OS/service/application, attack the thing you dislike, not the individuals who use it. Some people may not have a choice.
- Bigotry will not be tolerated.
3. Post Linux-related content
- Including Unix and BSD.
- Non-Linux content is acceptable as long as it makes a reference to Linux. For example, the poorly made mockery of
sudoin Windows. - No porn. Even if you watch it on a Linux machine.
4. No recent reposts
- Everybody uses Arch btw, can't quit Vim, <loves/tolerates/hates> systemd, and wants to interject for a moment. You can stop now.
5. π¬π§ Language/ΡΠ·ΡΠΊ/Sprache
- This is primarily an English-speaking community. π¬π§π¦πΊπΊπΈ
- Comments written in other languages are allowed.
- The substance of a post should be comprehensible for people who only speak English.
- Titles and post bodies written in other languages will be allowed, but only as long as the above rule is observed.
6. (NEW!) Regarding public figures
We all have our opinions, and certain public figures can be divisive. Keep in mind that this is a community for memes and light-hearted fun, not for airing grievances or leveling accusations. - Keep discussions polite and free of disparagement.
- We are never in possession of all of the facts. Defamatory comments will not be tolerated.
- Discussions that get too heated will be locked and offending comments removed. Β
Please report posts and comments that break these rules!
Important: never execute code or follow advice that you don't understand or can't verify, especially here. The word of the day is credibility. This is a meme community -- even the most helpful comments might just be shitposts that can damage your system. Be aware, be smart, don't remove France.
founded 2 years ago
MODERATORS
@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
Oh, that's really cool. I hope there's more linkage between the twitter-like and reddit-like islands of the fediverse in the future; I'm somewhat interested in reading the former but it seems to be complicated to actually get federation with it.
wow, that's simple! Thx!
load more comments
(3 replies)
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.
load more comments
(1 replies)
load more comments
(4 replies)
git repo is blockchain
everything is a file including a filesystem*
Β
* including databases
For example, a directory full of spreadsheets.
Somewhere, a sysadmin is pulling his hair out
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.
load more comments
(1 replies)
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
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.
load more comments
(1 replies)
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.
load more comments
(2 replies)
load more comments
(1 replies)
That's less the Unix way and more the BeOS way.
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.
And the worst FAT32
view more: next βΊ