Awesome ClickHouse › Golang

uptrace/go-clickhouse

⭐ 284 Go repository created 2022-01-23

The project "uptrace/go-clickhouse" is a Go client library designed specifically for interacting with the ClickHouse database server using its native protocol. It requires Go version 1.18 or higher to leverage generics, providing an efficient and modern API that is compatible with the standard database/sql interface but is not a database/sql driver itself. The client supports ClickHouse's column-oriented design, enabling efficient data operations. Key features include native protocol support, a Bun-like query builder for constructing SQL queries, and the ability to select data into various Go data structures such as scalars, structs, maps, and slices. It supports ClickHouse-specific data types like Date, DateTime, DateTime64, arrays (including nested arrays), enums, LowCardinality strings, and nullable types (except nullable arrays). The client also offers migration support and integrates with OpenTelemetry for monitoring and performance tracking. The project is actively used in production environments, notably by Uptrace, and provides comprehensive documentation, examples, and community support through discussions and chat. Benchmark tests demonstrate that this client performs faster in both read and write operations compared to other Go ClickHouse clients. Installation is straightforward via the Go package manager, and the repository includes example code illustrating basic usage such as connecting to the database, executing queries, inserting data, and retrieving results. The project also links to related tools like the Bun ORM for other databases and a Go HTTP router. Overall, this project offers a robust, high-performance, and feature-rich Go client for ClickHouse, making it suitable for developers looking to integrate ClickHouse into their Go applications with modern language features and efficient database interaction.

https://github.com/uptrace/go-clickhouse

arraybenchmarkingbun-like-query-builderclickhousedatabasedatabase/sql-compatibledatetimedocumentationenumexamplegogo-1.18+go-clientgolanglowcardinalitymigrationsnative-protocolnullableopentelemetryperformanceuptrace