django-clickhouse-backend
django-clickhouse-backend copied to clipboard
Django clickhouse database backend.
```python class Event(models.ClickhouseModel): class Action(IntegerChoices): PASS = 1 DROP = 2 ALERT = 3 ip = models.GenericIPAddressField(default="::") ipv4 = models.IPv4Field(default="127.0.0.1") ip_nullable = models.GenericIPAddressField(null=True) port = models.UInt16Field(default=0) protocol = models.StringField(default="", low_cardinality=True)...
**Describe the bug** On trying out the basic example provided in the repo, i got the below error on migration: ``` Running migrations: Traceback (most recent call last): File "/app/manage.py",...
implement [clickhouse](https://clickhouse.com/docs/en/sql-reference/aggregate-functions/reference/anylast) `anyLast` aggregate function.
Hi. I Want to get acces to Lazy Materialization on some Querys [Here is the article](https://clickhouse.com/blog/clickhouse-gets-lazier-and-faster-introducing-lazy-materialization) but nowere in the docs show how to add the "Settings" suffix on the...
Hello ! I've been using django-clickhouse-backend on one of my projects and it's been working great so far, so first of all thank you for your work :) I was...
There is currently no way to set `columnar=True` when using the DB API: ```py with connections['clickhouse'].cursor() as cursor: cursor.execute(sql, params) ``` From the code, it looks like: - For the...
ClickHouse supports data types for representing geographical objects — locations, lands, etc. Reference: https://clickhouse.com/docs/sql-reference/data-types/geo Would be pretty convenient to support geo location as field as I can't find a way...
**Describe the bug** The migration for a new clickhouse model defines the `objects` manager as the default django manager rather than the `ClickhouseManager` used in the base `ClickhouseModel` class. Accessing...
I noticed that the MergeTree engine is always applied to the migration table, which is why migration data is not replicated to other nodes, even with `"migration_cluster": "cluster"` in the...
Would be pretty convenient to configure TTL right through the django as I can't find a way to do so right now