ResearchSimon Willison

SQLite compressed text-history prototypes

#sqlite#compression#revision history#json#data storage

English

Simon Willison explores SQLite's compressed text-history prototypes, comparing two methods for storing revision histories: `WholeBlobHistoryStore` and `ChunkedHistoryStore`. His new idea involves using a JSON array of previous text versions compressed with zlib or zstd, demonstrating significant space savings in experimental tests.

中文

Simon Willison 探讨了 SQLite 的压缩文本历史原型，比较了两种存储修订历史的方法：`WholeBlobHistoryStore` 和 `ChunkedHistoryStore`。他的新想法是使用压缩的 JSON 数组存储先前文本版本，在实验测试中展示了显著的空间节省。