ClickHouse.Client
7.9.1
dotnet add package ClickHouse.Client --version 7.9.1
NuGet\Install-Package ClickHouse.Client -Version 7.9.1
<PackageReference Include="ClickHouse.Client" Version="7.9.1" />
paket add ClickHouse.Client --version 7.9.1
#r "nuget: ClickHouse.Client, 7.9.1"
// Install ClickHouse.Client as a Cake Addin #addin nuget:?package=ClickHouse.Client&version=7.9.1 // Install ClickHouse.Client as a Cake Tool #tool nuget:?package=ClickHouse.Client&version=7.9.1
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
- Composite types:
- 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
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.1 is compatible. |
.NET Framework | net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 is compatible. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.6.2
- Microsoft.Extensions.Http (>= 8.0.1)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- NodaTime (>= 3.2.0)
- System.Net.Http (>= 4.3.4)
- System.Text.Json (>= 8.0.5)
-
.NETFramework 4.8
- Microsoft.Extensions.Http (>= 8.0.1)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- NodaTime (>= 3.2.0)
- System.Net.Http (>= 4.3.4)
- System.Text.Json (>= 8.0.5)
-
.NETStandard 2.1
- Microsoft.Extensions.Http (>= 8.0.1)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- NodaTime (>= 3.2.0)
- System.Net.Http (>= 4.3.4)
- System.Text.Json (>= 8.0.5)
-
net6.0
- Microsoft.Extensions.Http (>= 8.0.1)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- NodaTime (>= 3.2.0)
- System.Net.Http (>= 4.3.4)
- System.Text.Json (>= 8.0.5)
-
net8.0
- Microsoft.Extensions.Http (>= 8.0.1)
- Microsoft.IO.RecyclableMemoryStream (>= 3.0.1)
- NodaTime (>= 3.2.0)
- System.Net.Http (>= 4.3.4)
- System.Text.Json (>= 8.0.5)
NuGet packages (32)
Showing the top 5 NuGet packages that depend on ClickHouse.Client:
Package | Downloads |
---|---|
Newguys.Sport
Package Description |
|
FreeSql.Provider.ClickHouse
FreeSql 数据库实现,基于 ClickHouse.Client Ado.net |
|
linq2db.LINQPad
Supported databases: IBM DB2 LUW/zOS, Firebird, IBM Informix, Microsoft Access, Microsoft Sql Server (+Azure), Microsoft Sql Server Compact, MySql, MariaDB, Oracle, PostgreSQL, SQLite, SAP HANA, SAP/Sybase ASE, ClickHouse. |
|
EntityFrameworkCore.ClickHouse
ClickHouse provider for Entity Framework Core. |
|
SqlSugar.ClickHouseCore
.NET ORM ClickHouse 组件 文档地址:https://www.donet5.com/Home/Doc?typeId=2437 |
GitHub repositories (6)
Showing the top 5 popular GitHub repositories that depend on ClickHouse.Client:
Repository | Stars |
---|---|
DotNetNext/SqlSugar
.Net aot ORM Fastest ORM Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
|
|
dotnetcore/FreeSql
🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, DuckDB orm, TDengine orm, QuestDB orm, MsAccess orm.
|
|
testcontainers/testcontainers-dotnet
A library to support tests with throwaway instances of Docker containers for all compatible .NET Standard versions.
|
|
linq2db/linq2db
Linq to database provider.
|
|
FastReports/FastReport
Free Open Source Reporting tool for .NET6/.NET Core/.NET Framework that helps your application generate document-like reports
|
Version | Downloads | Last updated |
---|---|---|
7.9.1 | 146 | 11/20/2024 |
7.9.0 | 127 | 11/19/2024 |
7.8.3 | 51 | 11/19/2024 |
7.8.3-alpha1 | 107 | 11/7/2024 |
7.8.2 | 10,850 | 10/13/2024 |
7.8.1 | 371 | 10/12/2024 |
7.8.0 | 19,632 | 9/21/2024 |
7.7.3 | 14,113 | 8/28/2024 |
7.7.2 | 1,416 | 8/28/2024 |
7.7.1 | 348 | 8/27/2024 |
7.7.0 | 3,494 | 8/25/2024 |
7.6.2 | 9,457 | 8/5/2024 |
7.6.1 | 347 | 8/2/2024 |
7.6.0 | 21,717 | 7/19/2024 |
7.5.3 | 3,559 | 7/15/2024 |
7.5.2 | 778 | 7/11/2024 |
7.5.1 | 20,414 | 6/17/2024 |
7.5.0 | 22,078 | 5/13/2024 |
7.3.0 | 7,346 | 4/17/2024 |
7.2.2 | 15,475 | 4/7/2024 |
7.2.1 | 8,928 | 3/25/2024 |
7.2.0 | 5,266 | 3/20/2024 |
7.1.1 | 36,128 | 2/18/2024 |
7.1.0 | 3,832 | 2/14/2024 |
7.0.0 | 26,808 | 1/14/2024 |
7.0.0-alpha1 | 233 | 12/24/2023 |
6.8.1 | 155,883 | 11/11/2023 |
6.8.0 | 21,917 | 11/6/2023 |
6.7.5 | 56,222 | 9/27/2023 |
6.7.4 | 66,939 | 8/4/2023 |
6.7.3 | 13,118 | 7/25/2023 |
6.7.2 | 15,537 | 7/12/2023 |
6.7.1 | 14,725 | 7/1/2023 |
6.7.0 | 42,040 | 6/14/2023 |
6.6.0 | 120,052 | 5/10/2023 |
6.5.2 | 40,936 | 4/7/2023 |
6.5.0 | 17,583 | 3/10/2023 |
6.4.0 | 36,939 | 1/28/2023 |
6.3.0 | 23,976 | 12/21/2022 |
6.2.0 | 17,766 | 11/22/2022 |
6.1.1 | 30,150 | 10/30/2022 |
6.0.0 | 21,689 | 10/13/2022 |
5.1.1 | 61,376 | 9/19/2022 |
5.1.0 | 14,360 | 9/14/2022 |
5.0.4 | 10,619 | 8/31/2022 |
5.0.3 | 40,906 | 8/6/2022 |
5.0.2 | 20,219 | 7/4/2022 |
5.0.1 | 547 | 7/3/2022 |
5.0.0 | 622 | 7/3/2022 |
4.3.1 | 1,397 | 6/30/2022 |
4.3.0 | 662 | 6/29/2022 |
4.2.2 | 120,244 | 2/23/2022 |
4.2.1 | 15,967 | 1/29/2022 |
4.2.0 | 566 | 1/29/2022 |
4.1.0 | 15,014 | 12/22/2021 |
4.0.1.462 | 61,320 | 10/23/2021 |
3.2.0.421 | 90,193 | 8/8/2021 |
3.1.0.379 | 72,411 | 4/7/2021 |
3.0.0.357 | 88,704 | 12/23/2020 |
2.3.0.326 | 14,555 | 11/26/2020 |
2.2.1.285 | 27,834 | 9/24/2020 |
2.2.0.279 | 8,020 | 9/19/2020 |
2.1.0.269 | 4,169 | 8/19/2020 |
2.0.0.262 | 1,545 | 7/1/2020 |
1.3.0.243 | 1,054 | 6/1/2020 |
1.2.0.230 | 9,848 | 5/14/2020 |
1.1.1.204 | 6,619 | 4/14/2020 |
1.1.0.197 | 1,102 | 3/29/2020 |
1.0.1.181 | 870 | 3/4/2020 |
1.0.0.174 | 745 | 2/21/2020 |
0.7.0.157 | 812 | 2/8/2020 |
0.6.0.144 | 623 | 2/3/2020 |
0.6.0.135 | 631 | 1/31/2020 |
0.5.0.106 | 676 | 1/1/2020 |
0.4.0.93 | 668 | 12/30/2019 |
0.2.0.69 | 1,133 | 11/25/2019 |
0.1.0.56-dev | 448 | 10/22/2019 |
0.1.0.49-dev | 428 | 10/20/2019 |
0.1.0.40-dev | 453 | 10/20/2019 |