Clickhouse is more marketed in my feeling. I mostly use Windows, so DuckDB is the first choice for me.

I didn’t realize they had chDB, honestly, need to give that a shot! The local CLI isn’t quite the same ergonomically