Add native driver for ClickHouse

[hanson-young]

Try Discussion?

Thank you for your outstanding contribution. I have read your paper and think it is great, but I suggest not using MySQL to support the connection to ClickHouse. It is better to use the native ClickHouse driver.

This is because the upstream library r2d2-mysql depends on https://github.com/blackbeam/rust-mysql-simple/tree/master, which performs some handshake operations when connecting to the database server, such as querying max_allowed_packet. Some of these commands are not supported by ClickHouse, which may lead to unsuccessful connections and make it difficult for users to get started directly.

Other

Feel free to ask here if you think it's more suitable.

[wangxiaoying]

Hi @hanson-young , thank you for starting this discussion! Indeed, we do observe some issues using mysql to connect to clickhouse both in terms of functionality (e.g., authentication) and performance. And it will be ideal if we can add a native clickhouse driver in connectorx. (I saw there are several clickhouse drivers in rust, not sure which one is the best choice.)