Simon Willison’s Weblog

Subscribe

Tuesday, 9th August 2022

sqlite-zstd: Transparent dictionary-based row-level compression for SQLite. Interesting SQLite extension from phiresky, the author of that amazing SQLite WASM hack from a while ago which could fetch subsets of a large SQLite database using the HTTP range header. This extension, written in Rust, implements row-level compression for a SQLite table by creating compression dictionaries for larger chunks of the table, providing better results than just running compression against each row value individually.

# 9:23 pm / sqlite, rust, zstd

2022 » August

MTWTFSS
1234567
891011121314
15161718192021
22232425262728
293031