django-clickhouse

What it is and what it does

django-clickhouse bridges Django applications and ClickHouse, a high-performance columnar database optimized for analytics and time-series workloads. It provides an ORM-like interface to define models and query ClickHouse tables, integrating with Django's ecosystem through celery for async operations and statsd for monitoring.

The package is designed for teams building analytics pipelines or real-time dashboards within Django projects. It abstracts ClickHouse's native query language and connection handling, letting developers work with familiar Django patterns. With low install friction and a permissive license, it's suitable for both open-source and commercial projects, though its dormant maintenance status means it receives no active updates.

Use it for:

• Build analytics dashboards in Django that query ClickHouse for aggregated metrics and time-series data.
• Migrate event logging or metrics collection from a traditional database to ClickHouse for better compression and query speed.
• Define ClickHouse tables as Django models and use celery tasks to batch-insert analytics events asynchronously.
• Integrate ClickHouse reporting into existing Django admin or custom views without rewriting query logic.
• Prototype analytics features in Django before committing to a dedicated analytics platform.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Integrates Django applications with ClickHouse, a columnar database, providing ORM-like access and query tools for analytics and time-series data workloads.

Yes, if you are already committed to ClickHouse and need Django integration—the low install friction, permissive license, and absence of known vulnerabilities make it a reasonable choice. However, verify that infi.clickhouse-orm is still maintained and that the package's dormant status does not hide unresolved compatibility issues with your Django version. Not recommended if you need active development or frequent updates.

Install

django-clickhouse on PyPI

pip install django-clickhouse

uv add django-clickhouse

poetry add django-clickhouse

Installing django-clickhouse

Before you install

Low install friction with a pure-Python wheel. Maintenance is dormant—last commit was 2025-02-19 but no releases in 541 days, suggesting the package is stable but not actively developed. Depends on Django, celery, infi.clickhouse-orm, pytz, statsd, and typing.

License in practice

BSD 3-clause permissive license allows commercial and private use with minimal restrictions, requiring only license and copyright notice retention.

Quickstart

pip install django-clickhouse

from django_clickhouse import ClickHouseModel

class MyAnalyticsModel(ClickHouseModel):
    pass

Requires a running ClickHouse server instance and infi.clickhouse-orm to be properly configured; Django project setup is also required.

Verify before relying

• Whether the package supports modern Django versions (3.2+, 4.x, 5.x) given no Python version constraint is specified.
• Current state of infi.clickhouse-orm dependency and whether it is actively maintained.
• Whether dormant status means the package is production-ready or has unresolved issues.

Package facts

Evidence: django_clickhouse-1.2.2-py2.py3-none-any.whl

Tags

More Front-Ends packages