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.
cloudflare/sqlalchemy-clickhouse
The project 'sqlalchemy-clickhouse' is a dialect for SQLAlchemy that enables integration with the ClickHouse database. It provides a way to use SQLAlchemy's ORM and SQL expression language capabilities with ClickHouse, a fast open-source column-oriented database management system. The package can be installed via pip and supports connection strings similar to those used for PostgreSQL, making it straightforward for users familiar with SQLAlchemy to connect to ClickHouse databases. It also supports SSL connections by adding an SSL parameter to the connection URL. The dialect itself does not expose a user-facing API but works as a backend dialect for SQLAlchemy, allowing developers to leverage SQLAlchemy's features while working with ClickHouse. For testing purposes, the dialect can be registered at runtime without requiring installation, which facilitates development and testing workflows. This project is particularly useful for developers and data engineers who want to use SQLAlchemy's powerful ORM and query capabilities with ClickHouse, enabling efficient data manipulation and querying in applications that require high-performance analytics and real-time data processing. Overall, 'sqlalchemy-clickhouse' bridges the gap between SQLAlchemy and ClickHouse, making it easier to integrate ClickHouse into Python applications that use SQLAlchemy for database interactions.
https://github.com/cloudflare/sqlalchemy-clickhouse
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.
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.
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.