The headline benchmark result is that on 10M rows, Stratum is faster than DuckDB on 35 of 46 single-threaded analytical queries, despite running entirely on the JVM.
But the main idea is actually branchable tables: you can fork a table in O(1), keep copy-on-write snapshots, and query different branches through SQL.
It speaks the PostgreSQL wire protocol, so psql/JDBC/DBeaver work out of the box.
Benchmarks, methodology, and repo are linked from the page. Happy to answer questions.
4 comments
[ 2.8 ms ] story [ 23.5 ms ] threadThe headline benchmark result is that on 10M rows, Stratum is faster than DuckDB on 35 of 46 single-threaded analytical queries, despite running entirely on the JVM.
But the main idea is actually branchable tables: you can fork a table in O(1), keep copy-on-write snapshots, and query different branches through SQL.
It speaks the PostgreSQL wire protocol, so psql/JDBC/DBeaver work out of the box.
Benchmarks, methodology, and repo are linked from the page. Happy to answer questions.
> Stratum is a columnar analytics engine that combines the performance of fused SIMD execution with the semantics of immutable data
What are your thoughts for investing in a columnar based database rather than a hybrid one?
I'm in the game development space.