aikodigital/clickhouse.client

.NET client for ClickHouse

ClickHouse.Client

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

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