#29821: Oracle Native JSON Field
-------------------------------------+-------------------------------------
Reporter: Vackar | Owner: nobody
Afzal |
Type: New | Status: new
feature |
Component: Database | Version: 2.0
layer (models, ORM) |
Severity: Normal | Keywords: Oracle Json
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Django has added JSONField for postgres databases.
Given that Oracle 12 now has native JSON columns, would be nice to expose
this in a similar fashion.
I've provided a reference implementation [here
https://github.com/Exscientia/oracle-json-field] and made it available via
[pip https://pypi.org/project/oracle-json-field/]. It is based heavily on
the Postgres implementation.
Note: In the reference implementation I have added a ```.filter_json()```
method whose only purpose is to ensure that table names are aliased - an
Oracle requirement for Json queries. If there is a cleaner way to force
table names to be aliased then this can be removed, and give 100% feature
parity with Django's core query API i.e. just use
```MyModel.objects.filter(...)```
Is this something that you would consider adding to the official Django
project. If so please feel free to re-use any of the code from the
reference implementation. Additionally I would be happy to create a pull-
request if it makes integration easier.
--
Ticket URL: <https://code.djangoproject.com/ticket/29821>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/054.75791d737e7e4e7763f8e3c15a48c9aa%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
