# phiresky/sqlite-zstd

Transparent dictionary-based row-level compression for SQLite

Repository: https://github.com/phiresky/sqlite-zstd
Canonical: https://ross.abutalabs.com/products/sqlite-zstd
Language: Rust
License: LGPL-3.0
License Family: copyleft
Last push: 2025-06-30T09:04:20+00:00

## Health v2 (maintenance only)
Score: 36/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 29, release rhythm 8, longevity 100
- inputs: {"age_days": 2377, "days_push": 429, "days_rel": 480, "gap_med": null, "n_releases_24m": 1}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1695, forks 70 (observed 2026-08-28T04:05:23.853723+00:00)

## What it is
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
- artifact type: library
- maturity: active
- function: compression, database, database-driver
- domain: databases, developer-tools, files
- platform: cross-platform, rust, cli
- tags: sqlite-extension, zstd, row-level-compression, loadable-extension

## Member repositories
- phiresky/sqlite-zstd (main) score 36

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:23.853723+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:37:56.951978+00:00, confidence not recorded.
  - readme: https://github.com/phiresky/sqlite-zstd (fetched 2026-08-28T04:05:23.853723+00:00, sha b0dbca24dd57)
  - registry_crates: https://crates.io/api/v1/crates/sqlite-zstd (fetched 2026-08-29T11:12:49.586921+00:00, sha bd01460a809c)
- Data as of 2026-08-30T08:39:29.467469+00:00.