DriftDB vs SQLite and DuckDB on 100 million rows
We loaded a year of sensor readings into three embedded databases and timed inserts, range scans and downsampling queries.
Kofi Mensah2 min read
Open source, Apache-2.0
Engineering notes, benchmarks and guides from the people who maintain DriftDB.
We loaded a year of sensor readings into three embedded databases and timed inserts, range scans and downsampling queries.
Format v2 shrinks files by 40% and makes crash recovery safe. Here is why we broke compatibility and how to migrate.
A short guide to writing and querying your first series with DriftDB from Rust or Python.