Awesome ClickHousePython

carrotquest/django-clickhouse

⭐ 105 Python repository created 2018-11-12

The project 'django-clickhouse' aims to integrate the Yandex ClickHouse database into Django projects, providing a seamless way to use ClickHouse within the Django framework. ClickHouse is a columnar database management system known for its high performance in analytical queries, making it suitable for big data and real-time analytics. This integration allows Django developers to leverage ClickHouse's capabilities directly in their applications, enhancing data processing and querying efficiency. The repository includes Python unit tests and automated workflows for testing and publishing the package, ensuring reliability and ease of deployment. The project is designed to be a bridge between Django and ClickHouse, enabling developers to use ClickHouse as a backend database or for specific analytical tasks within their Django applications. The documentation provided in the repository offers guidance on how to set up and use the integration effectively. By incorporating ClickHouse into Django, the project addresses the need for high-speed data analytics in web applications, allowing for faster data retrieval and processing compared to traditional relational databases. This can be particularly beneficial for applications that require real-time data analysis, large-scale data processing, or complex query handling. Overall, 'django-clickhouse' is a valuable tool for developers looking to enhance their Django applications with the power of ClickHouse, combining Django's robust web framework features with ClickHouse's advanced analytical database capabilities.

https://github.com/carrotquest/django-clickhouse

analytical-queriesautomated-workflowsbig-dataclickhousecomplex-query-handlingdata-analyticsdata-processingdatabase-integrationdjangohigh-speed-data-retrievallarge-scale-data-processingpythonquerying-efficiencyreal-time-analyticsunit-testsweb-applicationsyandex-clickhouse

Also in Python

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.

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.