[datadrivenangel]

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.

[ethin]

Agreed. And DuckDB certainly has a very nice API. But I wouldn't use it for a general dataset (think document storage).