HN Showcase
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, a column-oriented analytics extension for SQLite

by marcobambini·May 11, 2026·2 points·0 comments
Visit ProjectView on HN

AI Analysis

●●●BangerBig BrainWizardry

Brings DuckDB-style columnar speed to SQLite without replacing the engine.

Strengths
  • •130,000x speedup on specific aggregation benchmarks via columnar layout.
  • •Loadable extension architecture requires zero changes to existing SQLite apps.
Weaknesses
  • •Benchmarks rely on specific helper functions like columnar_sum, not raw SQL.
  • •Write performance likely suffers compared to standard row-oriented tables.
Category
Data
Target Audience

Data engineers needing local OLAP without a warehouse

Similar To

DuckDB · SQLite

Similar Projects

Data●●●Banger

SQLite-Columnar – Columnar Storage for SQLite

Columnar storage inside SQLite delivers 130,000x speedup on aggregation scans.

WizardryBig Brain
marcobambini
4021d ago