With indexes SQLite is very very fast even for aggregation at medium scales.
And DuckDB is reasonably fast for even single record writes. ~1000x slower than SQLite, but that's still pretty fast if you're only doing a few hundred writes per second or batching.
Comments
With indexes SQLite is very very fast even for aggregation at medium scales.
And DuckDB is reasonably fast for even single record writes. ~1000x slower than SQLite, but that's still pretty fast if you're only doing a few hundred writes per second or batching.
Agreed. And DuckDB certainly has a very nice API. But I wouldn't use it for a general dataset (think document storage).