chdb 0.2.2

chDB is an in-process SQL OLAP Engine powered by ClickHouse

chDB

chDB is an in-process SQL OLAP Engine powered by ClickHouse

Table of Contents

• Features
• Installation
• Usage
• Documentation
• Contributing
• License
• Acknowledgments
• Contact

Features

• In-process SQL OLAP Engine, powered by ClickHouse
• No need to install ClickHouse
• Minimal data copy from C++ to Python
• Input&Output support Parquet, CSV, JSON, Arrow, ORC and more

Installation

Currently, chDB only supports Python 3.7+ on macOS and Linux.

pip install chdb

Usage

Currently, chDB only supports query function, which is used to execute SQL and return desired format data.

import chdb
res = chdb.query('select version()', 'CSV'); print(str(res.get_memview().tobytes()))

work with Parquet or CSV

chdb.query('select * from file("data.parquet", Parquet)', 'Pretty')
chdb.query('select * from file("data.csv", CSV)', 'Pretty')

Documentation

• For SQL syntax, please refer to ClickHouse SQL Reference

Contributing

Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are greatly appreciated. There are something you can help:

• Report bugs on GitHub Issues.
• Help me with Windows support, I don't know much about Windows toolchain.
• The Python Wrapper just have a query function. I want to add more functions to make it more convenient to use. like toPandas, toNumpy and so on.

License

AGPL-v3.0 or Commercial License, see LICENSE for more information.

Acknowledgments

chDB is mainly based on ClickHouse for trade mark and other reasons, I named it chDB.

Contact

• Email: echo "YXV4dGVud3BjQGdtYWlsLmNvbQ==" | base64 -d
• Twitter: @auxten