{"repo":"jayvynl/django-clickhouse-backend","free":true,"listed":false,"github":"https://github.com/jayvynl/django-clickhouse-backend","clone":"git clone https://github.com/jayvynl/django-clickhouse-backend.git","description":"Django clickhouse database backend.","language":"Python","stars":198,"topics":["clickhouse","database","django","orm","python"],"license":"MIT","category":"databases-storage","readme_excerpt":"Django ClickHouse Database Backend === Django clickhouse backend is a django database backend for clickhouse database. This project allows using django ORM to interact with clickhouse, the goal of the project is to operate clickhouse like operating mysql, postgresql in django. Thanks to clickhouse driver, django clickhouse backend use it as DBAPI. Thanks to clickhouse pool, it makes clickhouse connection pool. Read Documentation for more. Features: - Reuse most of the existed django ORM facilities, minimize your learning costs. - Connect to clickhouse efficiently via clickhouse native interface and connection pool. - No other intermediate storage, no need to synchronize data, just interact directly with clickhouse. - Support clickhouse specific schema features such as Engine and Index. - Support most types of table migrations. - Support creating test database and table, working with django TestCase and pytest-django. - Support most clickhouse data types. - Support SETTINGS in SELECT Query. - Support PREWHERE clause. - Support SAMPLE clause. - Support query results returned in columns and deserialized to numpy objects. Notes: - Not tested upon all versions of clickhouse-server, clickhouse-server 22.x.y.z or over is suggested. - Aggregation functions result in 0 or nan (Not NULL) when data set is empty. max/min/sum/count is 0, avg/STDDEV POP/VAR POP is nan. - In outer join, clickhouse will set missing columns to empty values (0 for number, empty string for text, unix epoch for ","default_branch":null,"files":null,"tree":[],"storefront":"/r/jayvynl","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jayvynl/django-clickhouse-backend/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}