chDB is an embedded SQL OLAP Engine powered by ClickHouse. It offers various features, including in-process SQL OLAP engine, support for multiple input/output formats such as Parquet, CSV, JSON, Arrow, and more, and compatibility with Python DB API 2.0. Notably, chDB minimizes data copy from C++ to Python using python memoryview. It can be installed on macOS and Linux platforms and supports Python 3.8+. Users can execute SQL queries on different data formats, work with Pandas DataFrames, and even create stateful sessions. The tool also supports user-defined functions (UDFs) and offers extensive documentation and examples. Contributions to the project are welcome, and chDB is licensed under Apache 2.0. Contact information and acknowledgments are provided.
https://github.com/chdb-io/chdb