Simon Willison shares an experimental SQLite schema for efficient text revision history storage. The prototype uses zlib or zstd compression on a JSON array of historical text strings to drastically reduce storage overhead for frequently edited documents. The approach offers developers a lightweight, dependency-free alternative to traditional diff-based version control systems inside relational databases.
Opening Kapyn…