[Database] ClickHouse

[mehcode]

Details

• TCP
• Default port 9000
• ClickHouse protocol does not have formal specification yet, but it can be reverse-engineered from ClickHouse source code (starting around here) and/or by intercepting and analyzing TCP traffic: https://github.com/ClickHouse/ClickHouse/tree/master/src/Client

Prior Art

• https://github.com/suharev7/clickhouse-rs
• https://github.com/ClickHouse/clickhouse-go

[alexey-milovidov]

Here is the formal specification of the ClickHouse protocol:
https://clickhouse.com/docs/en/native-protocol

I also want this feature in sqlx!

[lovasoa]

Hi ! In case anyone here is interested, I just finished implementing support for ODBC to sqlx-oldapi, and I'm looking for people to help test it: https://docs.rs/sqlx-oldapi/0.6.49-beta.3

Open Database Connectivity (ODBC) is a standard API that allows decoupling applications and database drivers. Clickhouse has an official ODBC driver: https://github.com/ClickHouse/clickhouse-odbc