chDB and the ClickHouse ecosystem
Whether you're developing locally, running in-process analytics embedded in your app, or scaling production workloads, ClickHouse has you covered.
ClickHouse
chDB: ClickHouse In-Process
ClickHouse Local
Start using chDB in minutes
Install chDB for macOS and Linux
pip install chdbquery = "select count() FROM s3('s3://datasets-documentation/hackernews/hacknernews.json.gz')"
chdb.query(query,'DataFrame')
Open-source
library
chDB is an open-source library, allowing you to customize and extend your database to fit your needs. Benefit from a vibrant community that keeps you updated with the latest innovations and security practices.
Query objects
directly
With chDB, you can query native objects in the programming language of choice directly. This direct access reduces latency and simplifies data processing, enabling faster operations.
Supports Python
DB API 2.0
chDB supports Python DB API 2.0, ensuring seamless integration with your Python applications. Enjoy consistency, reliability, and ease of use with familiar libraries and tools.
chDB supports bindings for many programming languages, including:
Embedded. No need to install or run ClickHouse services
Streamline deployment with no additional setup
Reduce system complexity and resource usage
Ideal for lightweight and embedded applications
Minimized data copying from
C++ to Python
Enhance performance with direct memory access
Reduce overhead and latency in data processing
Achieve faster data handling and analysis
Input and output support
Parquet, CSV, JSON, Arrow,
ORC and 80+ more formats
Easily integrate with diverse data sources
Simplify data interchange and interoperability
Ensure compatibility with a wide range of data formats
chDB regularly outperforms DuckDB,
Pandas, and Polars in benchmark queries
With chDB, you have the benefit of ClickHouse's blazing speed, in-process.
For more details, check out our full benchmark results.
What is chDB used for?
Wherever you need us, we’re there. We love to engage in thoughtful conversation with the ClickHouse community and are always on-hand to answer your questions.
Ask us anything 01Testing your queries in CI without having to spin up a CH server
02Building self-contained prototypes/PoCs
03Jupyter notebooks without a CH Server running
Products
Stay informed on feature releases, product roadmap, support, and cloud offerings!
Loading form...
© 2024 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.