mymarilyn/clickhouse-driver
A Python driver providing native TCP interface support for efficient and secure interaction with ClickHouse databases, featuring extensive data type support and compliance with Python DB API 2.0.
kszucs/pandahouse
Pandahouse is a Python library that provides a convenient interface between the Pandas data analysis library and the ClickHouse database system. It enables users to seamlessly write Pandas DataFrames to ClickHouse tables and read data from ClickHouse queries directly into Pandas DataFrames. This integration facilitates efficient data manipulation and analysis workflows by combining the powerful data processing capabilities of Pandas with the high-performance analytical database features of ClickHouse. The library communicates with ClickHouse through its HTTP API, making it easy to connect and interact with ClickHouse servers. Users can specify connection parameters such as the host URL and database name to establish a connection. Once connected, Pandahouse offers simple functions like `to_clickhouse` to write data from a DataFrame to a specified ClickHouse table, and `read_clickhouse` to execute arbitrary SQL queries on ClickHouse and retrieve the results as DataFrames. Pandahouse is particularly useful for data scientists, analysts, and engineers who work with large datasets and require fast query performance combined with the flexibility of Pandas for data manipulation. By leveraging ClickHouse's columnar storage and query optimization, users can perform complex analytical queries efficiently and then use Pandas for further data processing, visualization, or machine learning tasks. Installation is straightforward via pip, making it accessible for Python users. The library's design focuses on simplicity and ease of use, allowing users to integrate ClickHouse into their data pipelines without needing to manage complex database drivers or configurations. Overall, Pandahouse bridges the gap between ClickHouse and Pandas, enabling streamlined workflows for data analysis and database interaction in Python environments.
https://github.com/kszucs/pandahouse
Also in Python
ClickHouse/clickhouse-connect
ClickHouse Connect is a high-performance Python driver that enables seamless integration of ClickHouse with Python data tools like Pandas, SQLAlchemy, and Apache Superset for efficient data access and visualization.
xzkostyan/clickhouse-sqlalchemy
Clickhouse-sqlalchemy is a SQLAlchemy dialect that enables seamless interaction with ClickHouse databases, supporting multiple connection interfaces and providing ORM capabilities for efficient data analytics.
Infinidat/infi.clickhouse_orm
infi.clickhouse_orm is a Python ORM library that simplifies working with the ClickHouse database by enabling easy model definition, data insertion, and querying.
cloudflare/sqlalchemy-clickhouse
sqlalchemy-clickhouse is a SQLAlchemy dialect that enables seamless integration with the ClickHouse database for efficient data querying and manipulation.
maximdanilchenko/aiochclient
aiochclient is a lightweight asynchronous HTTP client for Python that provides efficient and type-safe interaction with ClickHouse databases, supporting streaming, lazy decoding, and high performance through optional speedups.
long2ice/asynch
An asynchronous Python driver for ClickHouse with native TCP interface support, enabling efficient database interactions using asyncio.
jayvynl/django-clickhouse-backend
Django-clickhouse-backend is a Django database backend that enables seamless interaction with ClickHouse using Django ORM, supporting ClickHouse-specific features and efficient connection pooling.