SQLite compressed text-history prototypes

This article explores two SQLite prototypes for efficiently storing revision histories of text documents: WholeBlobHistoryStore and ChunkedHistoryStore. WholeBlobHistoryStore rewrites a single compressed blob containing all prior versions after each edit, while ChunkedHistoryStore seals compressed chunks to improve scalability for long histories. The author discusses using zlib or zstd compression on a JSON array of full text versions, and shares results from a simulation where 20.4 MB of raw revisions compressed to 80.3 KB. The article includes technical details on atomic updates, writer serialization, and skipping unchanged replacements, making it relevant for developers interested in database design and data compression.