Skip to content

Instantly share code, notes, and snippets.

@pirate

pirate/cockroach-django-orm.md

Last active April 16, 2019 16:19
Show Gist options
  • Star 8 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pirate/f2931acd97d52242756d85d52b42e8bd to your computer and use it in GitHub Desktop.
Save pirate/f2931acd97d52242756d85d52b42e8bd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cockroach-django-orm.md

CockroachDB + Django ORM

cockroachdb/sqlalchemy-cockroachdb#14

TODO

  1. fork django/contrib/postgres driver
  2. patch blocking postgres compatibility issues
  3. review with cockroachdb team to see if any issues can be fixed by cockroach
  4. review with django team
  5. merge adapter as separate cockroachdb adapter
  6. write docs, any admin work, etc.

Blocking Issues:

  • CREATE DATABASE "test__1" WITH TEMPLATE "test_" cockroachdb/cockroach#10151
  • pg_table_is_visible cockroachdb/cockroach#12538
  • uuid, time, inet datatypes (cockroachdb/cockroach#8719)
  • Function pg_catalog.pg_table_is_visible()
  • Directly interpreting timestamp literals from strings.
  • extract() function in extract('day' FROM '2010-02-20 00:00:00') format, 'dow' for 'dayofweek'.
  • date_tunc() function
  • Deferrable constraint checks. ("DEFERRABLE INITIALLY DEFERRED" for constraints cockroachdb/cockroach#9897)
  • Savepoints
  • Tablespaces
  • Schema changes inside transactions
  • Sequences, setval() function
  • Cursors
  • ALTER COLUMN TYPE cockroachdb/cockroach#5950
  • Operator patterns for varchar and text indexes.

Resources:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment