this post was submitted on 06 Jul 2024
932 points (99.4% liked)
Programmer Humor
18969 readers
1151 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 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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