ClickHouse C# Client Driver

A fast, low-latency, memory-efficient C# driver for ClickHouse database with native protocol support and strong static typing.

Quickstart

// Open connection
var options = new ClickHouseClientOptions { Host = "localhost" };
using var connection = new ClickHouseConnection(options);

// Create database and table
connection.Execute("CREATE DATABASE IF NOT EXISTS test");
connection.Execute("CREATE TABLE test.test (ts DateTime64(3), id UInt32, pressure Float64) ENGINE = Memory");

// Create some data to insert
using varts = new Column<ChDateTime64>();
using var id = new Column<ChUInt32>();
using var pressure = new Column<ChFloat64>();

for (var i = 0; i < 1_000_000; i++)
{
    ts.Add(DateTime.Now.Ticks);
    id.Add((uint)i);
    pressure.Add(1000.0 + i);
}

// Assign created columns to the block corresponding to the table
using var block = new ClickHouseBlock();
block.AppendColumn("ts", ts);
block.AppendColumn("id", id);
block.AppendColumn("pressure", pressure);

// Insert to table
connection.Insert("test.test", block);

Benchmarks

Here are the results of the benchmark (ClickHouse.Driver.Benchmarks) running on Ubuntu 22.04.

PC specs: AMD Ryzen 5 2400G, 8GB DDR4 RAM, 512GB HDD 7200RPM

For 1M rows inserted, ClickHouse.Driver is 5x faster than the second-fastest library (ClickHouse.Client)

Library	Insertion Time Ratio	Memory Usage
ClickHouse.Driver (this)	1x	1x
ClickHouse.Client	5.09x	3.33x
Octonica.ClickHouseClient	6.21x	0.71x
ClickHouse.Ado	63.35x	4.56x