quick aside and pointer to new benchmark #102
Description
clickhouse-local: faster than any of these but over 2GB so not a reasonable general-purpose CLI [1]
[1] https://github.com/multiprocessio/dsq#comparisons
In case it's of interest, clickhouse-local is recently available in a 50MB binary: ClickHouse/ClickHouse#29378
In ClickHouse's ClickBench benchmark, DuckDB fares particularly well in the embedded category that includes clickhouse-local, sqlite, and datafusion-cli.