AISimon Willisonabout 3 hours ago
SQLite compressed text-history prototypes
3 min read
A prototype stores every prior document version as a zlib or zstd compressed JSON array of strings in a SQLite BLOB column. Testing 1,000 simulated revisions compressed 20.4 MB of raw text to 80.3 KB. The approach splits history into rows of 128 revisions or 3MB to avoid full recompression.
Level
Hype check
Tap to vote and see what everyone thinks.
Summary by ByteBrief
