chdb
chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse
What is chdb?
chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse
Overview of chdb
What it is
chDB is an in-process SQL OLAP Engine powered by ClickHouse. It is designed to run embedded in applications without requiring a separate ClickHouse installation. The project also provides chDB-Wasm, a WebAssembly build that runs the full ClickHouse engine in the browser.
Key features
- Pandas-compatible DataStore API that allows using familiar pandas syntax with ClickHouse performance - Runs in the browser via WebAssembly (chDB-Wasm) at wasm.chdb.io - In-process SQL OLAP Engine, no need to install ClickHouse - Minimized data copy from C++ to Python using Python memoryview - Input and output support for Parquet, CSV, JSON, Arrow, ORC and 60+ other formats - Supports Python DB API 2.0
Use cases
Use cases include in-process OLAP queries, data analysis with a pandas-like API, querying files in various formats (Parquet, CSV, JSON, etc.), and running SQL directly in the browser via WebAssembly.
Getting started
Install chDB via pip: bash pip install chdb For ADBC support (Python 3.10+): bash pip install 'chdb[adbc]' Run a quick SQL query from the command line: bash python3 -m chdb 'SELECT 1,'abc'' Pretty For a no-install option, open wasm.chdb.io in a browser. To use the DataStore API, change your import: python import datastore as pd
License and pricing
The project is licensed under Apache-2.0 and is open source.
Based on the project's public README and repository metadata.