phiresky/sqlite-zstd

Health v2 · maintenance only

Adoption not part of the score

1695 stars · 70 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A SQLite loadable extension written in Rust that provides transparent dictionary-based row-level compression using zstd. It compresses table columns while retaining full random access by replacing tables with views backed by compressed shadow tables.

Use cases

• compress large text or blob columns in a sqlite database
• reduce sqlite database file size while keeping random access
• store compressed documents in sqlite transparently
• shrink disk usage of sqlite-backed applications
• compress sqlite rows with trained zstd dictionaries

When to choose

• you use SQLite and want row-level compression with normal SELECT/INSERT/UPDATE/DELETE queries
• your data is highly repetitive text or blobs and file size matters more than peak write speed
• you want incremental, tunable compression maintenance

When to avoid

• you need full DDL support like ALTER TABLE or CREATE INDEX on compressed tables
• you rely on sqlite3_changes() or streaming blob APIs
• you need to ATTACH databases containing compressed tables
• a whole-file compression VFS approach fits your workload better

Facets

library · maturity active

compression database database-driver databases developer-tools files cross-platform rust cli sqlite-extension zstd row-level-compression loadable-extension

Member repositories

For agents

markdown · JSON · MCP: product_card(name="phiresky/sqlite-zstd")