sqlx icon indicating copy to clipboard operation
sqlx copied to clipboard
verified publisher icon launchbadge

[Database] ClickHouse

Open mehcode opened this issue 5 years ago • 2 comments

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

mehcode avatar Jul 19 '20 03:07 mehcode

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

I also want this feature in sqlx!

alexey-milovidov avatar Dec 27 '22 11:12 alexey-milovidov

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

lovasoa avatar Sep 26 '25 20:09 lovasoa