django-cockroachdb
django-cockroachdb copied to clipboard
cockroachdb
CockroachDB Backend for Django
Relaying feedback that I received from one of our customers: > App devs have run into problems during upgrade of django-cockroachdb. The plugins dependencies do not seem to limit usage...
Hi, given the release of [trigram indexes](https://www.cockroachlabs.com/docs/v23.1/trigram-indexes#how-do-trigram-indexes-work), I have tried to implement them in my django app. However, the migrations are failing. From what I can tell, django-cockroachdb hasn't been...
Is there an any support for [`AS OF SYSTEM TIME`](https://www.cockroachlabs.com/docs/stable/as-of-system-time.html) in either the transaction variant: ```sql BEGIN AS OF SYSTEM TIME '2019-04-09 18:02:52.0+00:00'; ``` or the query variant: ```sql SELECT...
Dividing an integer column by another integer in an `UPDATE` query crashes: ``` ====================================================================== ERROR: test_lefthand_division (expressions.tests.ExpressionOperatorTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/opt/python3.7.0/lib/python3.7/unittest/case.py", line 59, in testPartExecutor yield...
This is about CRDB's hash sharded index feature for sequential indexes / primary keys: https://www.cockroachlabs.com/blog/hash-sharded-indexes-unlock-linear-scaling-for-sequential-workloads/ Is there any way to use this feature? I've tried passing various arguments to `_create_index_sql()`:...
For example: ``` ====================================================================== ERROR: test_mixed_type_annotation_numbers (annotations.tests.NonAggregateAnnotationTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/home/tim/code/django/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) psycopg2.errors.InvalidParameterValue: unsupported binary operator: + ``` Is there...
Django 3.0 adds support for [SmallAutoField](https://github.com/django/django/commit/194d1dfc186cc8d2b35dabf64f3ed38b757cbd98), however, cockroachdb's `unique_rowid()` generates 8-byte values that are too large for `int2` (2-byte). I'm not sure how to proceed. Test failure: ``` ====================================================================== ERROR:...
Example query: ```sql SELECT ... sum((("aggregation_book"."rating" + "aggregation_book"."pages") + "aggregation_book"."price")) AS "sums" FROM "aggregation_book" WHERE "aggregation_book"."id" = 501322346762469377 GROUP BY "aggregation_book"."id"; ``` Where `rating` is `FloatField` and `pages` is `IntegerField`....