STANCHION

Summary from the TLDR newsletter

Stanchion is an SQLite 3 extension that enables column-oriented storage in SQLite. It brings all of the benefits of column-oriented storage and data warehousing to anywhere SQLite is already deployed. Column-oriented storage outperforms row-oriented storage for storing and processing metric, log, and event data, time series data storage and analysis, change tracking, and anchor modeling. Stanchion uses compression techniques that significantly reduce the size of stored data, greatly reducing the cost of large data sets.