SQLite compression shrinks 20 MB of revisions to 80 KB
Simon Willison prototyped a SQLite schema that stores every document revision as a Zstandard‑compressed JSON array in a BLOB, reducing 20 MB of raw history to about 80 KB. The design also splits history into rows to avoid re‑compressing the whole file on each edit, offering a lightweight version‑control alternative without external services.