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.
mymarilyn/aioch
aioch is an asynchronous Python library designed to provide access to ClickHouse databases using the native interface within the asyncio framework. It serves as a wrapper around the clickhouse-driver library, enabling asynchronous operations for executing queries and managing database interactions efficiently. The library supports features such as executing queries with progress tracking, allowing users to monitor the progress of long-running queries and even cancel them based on custom conditions, such as elapsed time or percentage of rows processed. This capability is particularly useful for handling complex or time-consuming queries in an asynchronous environment. Installation of aioch is straightforward via pip or from source, making it accessible for developers to integrate into their projects. The library is designed to work seamlessly with asyncio's event loop, providing asynchronous execution of queries and handling results without blocking the main application flow. Users can create a Client instance connected to a ClickHouse server and perform operations like executing queries with or without progress feedback. The library also allows customization through parameters such as providing a custom Executor instance or specifying an asyncio-compatible event loop, offering flexibility for advanced use cases. aioch is distributed under the MIT license, ensuring it is free to use and modify. Overall, aioch is a valuable tool for developers needing asynchronous interaction with ClickHouse databases, leveraging Python's asyncio capabilities to improve performance and responsiveness in applications that require efficient database communication.
https://github.com/mymarilyn/aioch
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.
kszucs/pandahouse
Pandahouse is a Python library providing a Pandas interface to interact with ClickHouse databases via HTTP API for efficient data reading and writing.