923
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 06 Jul 2024
923 points (100.0% liked)
Programmer Humor
19804 readers
455 users here now
Welcome to Programmer Humor!
This is a place where you can post jokes, memes, humor, etc. related to programming!
For sharing awful code theres also Programming Horror.
Rules
- Keep content in english
- No advertisements
- Posts must be related to programming or programmer topics
founded 2 years ago
MODERATORS
Sqlite is a great embedded database.
If you are storing lots and lots of information in a JSON file, CSV file, or coming up with your own serialisation... Chances are, sqlite is going to do it better.
I know loads of android apps use sqlite for storage. I've also managed to open quite a few programmes "proprietary" file format in sqlite.
A yes, the two genders of binary file formats: renamed sqlite file and renamed zip folder.
Don't forget renamed and compressed xml + zip
Aren't sqilte files themselves (like most other things) just fancy text files?
Nah, only actual string data is stored as text. Everything else is stored as binary: https://www.sqlite.org/fileformat.html#record_format
The file also isn't written sequentially, it's stored in blocks (pages), where sometimes later data can be inserted in the middle (e.g. when data was deleted).
I did say fancy.
Then I guess my laptop is just a fancy boat.
Haven't seen your laptop, but if it's anything like mine it's a very lousy boat.
Ahoy sailor
No: https://www.sqlite.org/fileformat.html