this post was submitted on 13 Sep 2023
683 points (97.6% liked)
Programmer Humor
32472 readers
880 users here now
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
- Posts must be relevant to programming, programmers, or computer science.
- No NSFW content.
- Jokes must be in good taste. No hate speech, bigotry, etc.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Ah, good ol' Microsoft Office. Taken advantage of their documents being a renamed .zip format to send forbidden attachments to myself via email lol
On the flip side, there's stuff like the Audacity app, that saves each audio project as an SQLite database π³
Also .jar files. And good ol' winamp skins. And CBZ comics. And EPUB books. And Mozilla extensions. And APK apps. And...
cbz is literally just a renamed zip
Btw, you can create "chapters" by creating folders. Easy to automate with a loop.
a lot of the time i handle it manually since i try to pack things in "volumes" that most closely mimic physical releases, and writing the code to get that information would be slower than just looking it up manually
so, for example, the first volume of bleach has 7 chapters, so i'd pack those 7 chapters together into one cbz, the second volume in another cbz, etc.
Genius! Why bother importing and exporting
Minetest (an open-source Minecraft-like game) uses SQLite to save worlds.
Mineclone2 is an absolute masterpiece of a game for Minetest IMO
I prefer games that embrace the difference from Minecraft instead of trying to emulate it. My favorite is MeseCraft.
So does Scrap Mechanic (sandbox game that's basically Space Engineers on the ground -- or, more loosely, Minecraft but with physics and you can build cars) also uses sqlite to save worlds. It also uses uncompressed JSON files to store user creations.
It used to use project folders, but due to confusion/user error was changed in 3.0.
SQLite is amazing. Shush.
Is this a problem? I thought this would be a normal use case for SQLite.
doesn't sqlite explicitly encourage this? I recall claims about storing blobs in a sqlite db having better performance than trying to do your own file operations
Thanks for the hint. I had to look that up. (The linked page is worth a read and has lots of details and caveats.)
The scope is narrow, and well documented. Be very wary of over generalizing.
https://www.sqlite.org/fasterthanfs.html
Edit 5: consolidated my edits.
wait what
Civilisation (forget which) runs on an SQLite DB. I was rather surprised when I discovered this, back then.