691
submitted 9 months ago by yogthos@lemmy.ml to c/programmerhumor@lemmy.ml
you are viewing a single comment's thread
view the rest of the comments
[-] dan@upvote.au 8 points 9 months ago* (last edited 9 months ago)

SQLite explicitly encourages using it as an on-disk binary format. The format is well-documented and well-supported, backwards compatible (there's been no major version changes since 2004), and the developers have promised to support it at least until the year 2050. It has quick seek times if your data is properly indexed, the SQLite library is distributed as a single C file that you can embed directly into your app, and it's probably the most tested library in the world, with something like 500x more test code than library code.

Unless you're a developer that really understands the intricacies of designing a binary data storage format, it's usually far better to just use SQLite.

this post was submitted on 13 Sep 2023
691 points (97.7% liked)

Programmer Humor

31229 readers
52 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 4 years ago
MODERATORS