[qaq]

thats a strange argument DuckDB is for OLAP and SQLite is for OLTP

[da_chicken]

Yeah, but most applications are small. So, at the scale of most applications you can drop in DuckDB with zero change in actual performance. It still has indexes to support highly selective queries because it needs to have functional primary keys.