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.
long2ice/asynch
The project 'asynch' is an asynchronous Python driver designed specifically for ClickHouse, a columnar database management system. It supports native TCP interface communication, enabling efficient and high-performance interactions with ClickHouse servers. The driver is built to comply with Python's DB API specification (PEP 249), ensuring a standardized and familiar interface for developers. 'asynch' reuses many features from the well-known 'clickhouse-driver' project, enhancing its capabilities while providing asynchronous support using Python's asyncio framework. Installation is straightforward via pip, with optional support for transport compression through an additional package. The driver allows connections to ClickHouse servers either through a DSN string or by specifying connection parameters such as user, password, host, port, and database. It provides a Cursor class and a DictCursor subclass for executing SQL statements and fetching results in tuple or dictionary formats, respectively. The project supports creating databases and tables, executing queries, and inserting data using both dictionaries and tuples. It also includes a connection pooling mechanism to manage multiple connections efficiently, with improvements introduced in version 0.2.5 for better pool management. The project is actively maintained with continuous integration and packaging workflows, and it is licensed under the Apache-2.0 License. Overall, 'asynch' is a robust and efficient asynchronous driver for Python developers working with ClickHouse, offering native protocol support, ease of use, and advanced features like connection pooling and data insertion flexibility.
https://github.com/long2ice/asynch
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.
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.
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.