ClickHouse.Client

Fast binary-over-HTTP ADO.NET provider for ClickHouse


Keywords
ado.net, clickhouse, client, ado-net, database, dotnet
License
MIT
Install
Install-Package ClickHouse.Client -Version 7.3.0

Documentation

ClickHouse.Client

ADO.NET client for ClickHouse, ultra-fast 'big data' relational database

Latest version Downloads License Tests

Key features

  • High-throughput
  • Fully supports ClickHouse-specific types:
    • Composite types: Array, Tuple, Nullable, Nested, Map, including combinations
    • Specialized types: IPv4, IPv6, UUID, DateTime64, LowCardinality, Enum etc.
    • Large arithmetic types: (U)Int128, (U)Int256, Decimal128, Decimal256
    • Note: JSON type support was officially dropped from ClickHouse itself
  • Correctly handles DateTime, including time zones
  • Supports bulk insertion
  • Uses compressed binary protocol over HTTP(S)
  • Available for .NET Core/Framework/Standard

Advantages

Compared to other existing .NET clients, ClickHouse.Client has following advantages

  • Does not have to buffer response, reducing memory usage
  • Offers wider support for ClickHouse-specific types
  • Is more compliant to ADO.NET standards (e.g. does not require calling 'NextResult' on SELECT queries)
  • Works with ORM like Dapper, Linq2DB, Entity Framework Core etc.

Documentation

Documentation for the library is available in repository Wiki