I think you’re thinking of TigerBeetle, not Clickhouse, which is a quite performant db with a fascinating simulation-tested story and proof of performance / safety.

ClickHouse is written in C++ (un)fortunately. Although I do think that Zig would fit it quite well too

Yeah ClickHouse is written in C++, though rust is also possible https://clickhouse.com/blog/rust - would be cool to see zig!