Data●●●Banger
Stratum – SQL that branches and beats DuckDB on 35/46 1T benchmarks
Git-like branching for columnar data with DuckDB-beating benchmarks from pure JVM.
Big BrainWizardry
whilo
1233mo ago
Back to browse
Stratum - a pure JVM columnar SQL engine using the Java Vector API
by whilo·Mar 6, 2026·3 points·1 comment
AI Analysis
●●SolidBig BrainWizardry
Java Vector API beats DuckDB on 35/46 queries; O(1) table branching via structural sharing.
Strengths
- •Genuine vectorization win: fused SIMD execution over copy-on-write columns yields measurable 2–8.5× speedups on real TPC-H and H2O queries
- •O(1) branching is clever: structural sharing with persistent sync creates low-cost snapshots across Datahike/Stratum/Proximum stack
- •No native dependencies and PostgreSQL wire protocol mean it plugs into standard tools (psql, JDBC, DBeaver)
Weaknesses
- •DuckDB still faster on sparse filters and high-cardinality aggregates—no clear moat, only wins on specific query patterns
- •Ecosystem lock-in: compelling only if you're already invested in Datahike (Datalog + time-travel DB); standalone appeal is niche
Category
Target Audience
Java-based data platforms, analytics engineers, Datahike ecosystem users needing SIMD-optimized SQL
Similar To
DuckDB · Presto/Trino · Polars
Similar Projects
Infrastructure●●Solid
High perfomance database - Graph, vector, array, columnar, KV
Replaces PostgreSQL + Redis + Neo4j + ClickHouse with one Rust binary.
Big BrainSolve My Problem
fs90
301mo ago
AI/ML●●Solid
PardusDB – SQLite-like vector database in Rust
Using a single-file .pardus format with CREATE/INSERT/SELECT + SIMILARITY queries gives a very familiar developer UX for embedding storage. The combination of graph-based ANN, full transactions, thread-safety, and zero external dependencies is an uncommon and useful engineering combo for local-first AI work; it would win more attention with benchmark comparisons and richer ecosystem integrations (connectors/clients).
Niche GemWizardry
JasonHEIN
204mo ago
Developer Tools●●Solid
pgtk - Pure SQL diagnostic functions for PostgreSQL
Zero-install Postgres diagnostics, but pg_stat_statements and pgAdmin already exist.
Solve My ProblemNiche Gem
mnafees
103mo ago
Developer Tools●●●Banger
MegaHAL in Pure SQL
MegaHAL chatbot runs in pure SQL—no PL/pgSQL escape hatches, just CTEs and recursive queries.
WizardryBig BrainNiche Gem
tgies
113mo ago
AI/ML●●Solid
Replaced Neo4j with pure vector search for Graph RAG
Graph RAG without Neo4j — pure vector search beats HippoRAG on multi-hop benchmarks.
Big BrainDark Horse
zhangchen
202mo ago