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
201mo 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.
4 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
SaaS●●Solid
Fusionaly, Web Analytics with SQLite
SQLite beats PostgreSQL for single-tenant analytics—simpler stack, same results.
Solve My ProblemSlick
karloscodes
433mo 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
423mo 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
101d ago
Data●●Solid
Pg_deltax, Apache-licensed alternative to TimescaleDB
Stores columnar data in regular Postgres tables so pg_dump and replication just work.
Niche Gem
tee-es-gee
39125d ago
Developer Tools●●Solid
Kerf-CLI – SQLite-backed cost analytics for Claude Code
PreToolUse hooks block over-budget requests while SQLite tracks Claude Code spend locally.
Solve My ProblemNiche GemCozy
dhanushkumars
902mo ago