Simon Willison is researching options for efficiently storing revision histories in relational databases, specifically exploring SQLite prototypes for compressed text history. His new idea involves storing the full text of prior versions in a JSON array and applying compression techniques.
Source: Simon Willison