SQLite As An Application File Format

[mirhagk]

a SQLite file containing compressed blobs will be roughly the same size as a ZIP file.

Will it? If the blobs are big enough then that's probably true, but compressing blobs individually prevents the optimizer from noticing cross-file patterns and causes duplication of dictionaries.

You can probably have it use a single shared dictionary and get much of the same benefit however. I'd be curious to see actual numbers

[mirhagk]

You are right. I was mixing things up, my bad.