Edge Rewrite
// request.cf · coarse context

A page that knows where it met you.

Only coarse request metadata is shown. This demo does not display or persist visitor IP addresses.

Country
US
Cloudflare location
CMH
Connection
HTTP/2
Language
Not provided

Ray ID: a44e0f861a218020

Jump to content

Draft:chDB

From Wikipedia, the free encyclopedia
  • Comment: Topic not notable. Further you have used an LLM to assist your draft three different times even after being clearly instructed not to. We will not consider this draft further. Sulfurboy (talk) 02:15, 14 August 2026 (UTC)
  • Comment: Please rewrite from scratch without the use of LLMs. Corporate blogs are not reliable sources. Helpful Raccoon (talk) 23:23, 3 June 2026 (UTC)


chDB
Original authorAuxten Wang
DevelopersClickHouse, Inc.
Release2023
Written inC++, Python, JS, Rust, Go
Operating systemmacOS, Linux
TypeEmbedded database, OLAP
LicenseApache License 2.0
Websiteclickhouse.com/chdb
Repositorygithub.com/chdb-io/chdb

chDB is an open-source embedded ClickHouse for online analytical processing (OLAP). It compiles the ClickHouse engine within a cross-platform library and provides language bindings for C/C++, Python, Go, Node, Rust.[1] It allows applications to run ClickHouse query directly within the process, without requiring a separate database server. [2][3]

History

[edit]

chDB was created by Auxten Wang and the Python version was first released in 2023 followed by support for multiple programming languages. It was acquired by ClickHouse, Inc in March 2024 and introduced WebAssembly (Wasm) support in July 2026.[4][3]

Design

[edit]

The design principle of chDB is to reduce data copying between application memory and ClickHouse engine. Queries can operate directly on objects already in memory, such as a pandas DataFrame in a Jupyter notebook, and return the results into the same session.[2]

chDB uses the same SQL dialect as ClickHouse and can read more than 70 data formats, like Parquet, CSV and JSON. [5][6][7]. It also supports federated queries that combine in-memory data and remote data sources without first loading them into a database server.[7] Since chDB v4, the Python API has supported a pandas-compatible DataStore, allowing it to work directly with dataframes.[8]

As an embedded OLAP database, chDB is often compared with DuckDB for local analytics.[9][10] It is particularly suitable for developers already working with ClickHouse, especially when a workload relies on ClickHouse-specific SQL features such as array functions or when a ClickHouse-based project needs a light-weight environment for testing.[9][10]

References

[edit]
  1. ↑ "chdb-io/chdb". GitHub. chdb-io. Retrieved 2026-06-04.
  2. 1 2 Schulze, Robert; Schreiber, Tom; Yatsishin, Ilya; Dahimene, Ryadh; Milovidov, Alexey (2024). "ClickHouse - Lightning Fast Analytics for Everyone" (PDF). Proceedings of the VLDB Endowment. 17 (12): 3731–3744. doi:10.14778/3685800.3685802.
  3. 1 2 "chDB". Database of Databases. Carnegie Mellon University Database Group. 14 March 2024. Retrieved 2026-06-04.
  4. ↑ Milovidov, Alexey; Bragin, Tanya (2024-03-06). "chDB joins the ClickHouse family". ClickHouse Blog. ClickHouse, Inc. Retrieved 2026-06-04.
  5. ↑ Archer, Cameron (2025-10-27). "ClickHouse vs chDB: let's talk about embedded ClickHouse". Tinybird. Retrieved 2026-06-04.
  6. ↑ Orlov, Dmitrii (2024). Knowledge Graphs at Your Fingertips: a Survey of Kaggle Notebooks for Knowledge Graph Analytics (PDF) (Master's thesis). Eindhoven University of Technology.
  7. 1 2 Zhiyanov, Anton (2023-12-11). "Trying chDB, an embeddable ClickHouse engine". Anton Zhiyanov's blog. Retrieved 2026-06-04.
  8. ↑ Wang, Xiaoying; Wang, Jiannan; Wang, Tianzheng; Zhang, Yong (2025). "Accio: Bolt-on Query Federation" (PDF). Proceedings of the VLDB Endowment. 18 (7): 2126–2135. doi:10.14778/3734839.3734849.
  9. 1 2 Krupitsky, Daniel (2025-03-25). "Small-Scale Data Pipeline: DuckDB vs. chDB vs. Spark". Digital Turbine. Retrieved 2026-06-04.
  10. 1 2 Roset, Martin-Pierre (2026-04-15). "Embedded Databases in 2026: DuckDB, SQLite, Polars, and chDB". Kestra. Retrieved 2026-06-04.