Data●●●Banger
SQLite-columnar, a column-oriented analytics extension for SQLite
Brings DuckDB-style columnar speed to SQLite without replacing the engine.
Big BrainWizardry
marcobambini
202mo ago
Back to browse
GitHub Repository
Column-oriented analytics for SQLite, designed for fast local analytical queries with benchmarked speedups of up to 130,000x over standard SQLite scans on selected workloads.
7 starsC
SQLite-Columnar – Columnar Storage for SQLite
by marcobambini·May 13, 2026·4 points·0 comments
AI Analysis
●●●BangerWizardryBig Brain
Columnar storage inside SQLite delivers 130,000x speedup on aggregation scans.
Strengths
- •Self-contained loadable extension requires no SQLite source patches.
- •Chunk-level metadata tracking enables massive speedups on range queries.
- •Specialized aggregate functions avoid generic row materialization overhead.
Weaknesses
- •Only three stars suggests limited real-world testing or documentation.
- •Columnar benefits vanish on point lookups, requiring hybrid table design.
Category
Target Audience
Backend developers needing OLAP capabilities without a data warehouse
Similar To
DuckDB · ClickHouse · Apache Parquet
Similar Projects
Infrastructure●●●Banger
Loomabase – Column-level CRDT sync for SQLite + Postgres
Column-level CRDTs prevent overwrite conflicts that row-level sync causes.
WizardryBig BrainBold Bet
vforno
201mo ago
Infrastructure●●Solid
Loomabase – Offline-first column-level CRDT sync for SQLite + Postgres
Column-level CRDTs beat row-level sync when edits conflict across devices.
Big BrainWizardry
vforno
201mo ago
SaaS●●Solid
Fusionaly, Web Analytics with SQLite
SQLite beats PostgreSQL for single-tenant analytics—simpler stack, same results.
Solve My ProblemSlick
karloscodes
434mo ago
Productivity●●Solid
Flumen – An open-source focus timer for macOS (menu bar, local data)
Beautiful macOS timer replaces bloated SaaS competitors, but Toggl and Be Focus already dominate.
CozySolve My Problem
saranshbarua01
425mo ago
Infrastructure●●●Banger
Loomabase – Offline-first sync for SQLite and PostgreSQL
Column-level CRDTs prevent unrelated offline edits from overwriting each other.
Big BrainWizardry
vforno
201mo ago