Show HN: SQLite-columnar, a column-oriented analytics extension for SQLite

Category: infrastructure

Tags: sqlite, columnar-storage, analytics, olap, embedded-database

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

SQLite-Columnar is a loadable C extension that adds column-oriented storage and execution to SQLite for analytical OLAP queries, enabling massive speedups on aggregations and scans while keeping the operational simplicity of a single-file database. It uses shadow tables, chunk-level metadata, and specialized aggregate functions to achieve sub-second performance on local datasets, making it interesting for embedded analytics, time-series, and edge computing use cases.

Target audience: backend devs, data engineers, devops

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

View on Hacker News