Show HN: SQLite-Columnar – Columnar Storage for SQLite

Category: infrastructure

Tags: columnar-storage, olap, sqlite-extension

Score: 7.5/10 (Innovation: 7, Technical: 8, Documentation: 8, Utility: 7)

SQLite-Columnar is a loadable extension that brings column-oriented storage and analytical query execution to SQLite, enabling sub-second OLAP queries on local files. It achieves dramatic speedups (up to 130,000x) for aggregations and range scans over wide datasets by storing each column separately with chunk-level metadata and specialized aggregate functions, all without modifying SQLite's core. This project is interesting because it bridges the gap between SQLite's simplicity and the performance needs of analytical workloads, making embedded analytics practical for edge, desktop, and SaaS applications.

Target audience: backend devs, data engineers, devops

Repository: https://github.com/sqliteai/sqlite-columnar · C · NOASSERTION · 3 stars

View on Hacker News