#35718: Some useful postgres functions for JSON are missing from contrib
----------------------------------+---------------------------------------
Reporter: john-parton | Owner: john-parton
Type: New feature | Status: assigned
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution:
Keywords: | Triage Stage: Unreviewed
Has patch: 1 | Needs documentation: 1
Needs tests: 1 | Patch needs improvement: 1
Easy pickings: 0 | UI/UX: 0
----------------------------------+---------------------------------------
Comment (by Sarah Boyce):
Thank you both for the discussion
When requesting new feature for Django, we recommend to first propose and
discuss the idea with the community and gain consensus on the
[https://forum.djangoproject.com/c/internals/5 Django Forum].
There is a broader audience active on the forum (or the developers mailing
list) and that helps to receive additional feedback and agree on the
direction.
It would be nice for us to close out this discussion here, and migrate any
open points to the forum, and any agreed items to perhaps new tickets
(referring to this one).
If we're in agreement, I think we can create a ticket to add
`django.db.models.functions.JSONArray`, similar to
`django.db.models.functions.JSONObject` (#32179).
I think these might be equivalent:
[https://dev.mysql.com/doc/refman/8.4/en/json-creation-functions.html
#function_json-array MySQL JSON_ARRAY],
[https://www.sqlite.org/json1.html#jarray SQLite json_array],
[https://docs.oracle.com/en/database/oracle/oracle-
database/23/sqlrf/JSON_ARRAY.html Oracle JSON_ARRAY].
The rest I think needs more investigation/discussion.
I thought `json_array_elements` might be equivalent to `JSON_EXTRACT` /
`json_extract` for MySQL and SQLite respectively, but for Oracle I'm not
sure (`JSON_VALUE` maybe). I'm likely to be wrong and think it needs more
looking into
--
Ticket URL: <https://code.djangoproject.com/ticket/35718#comment:8>
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/01070191b1ee8b1a-41c654e5-e637-478b-a482-3c23f0f0d8f3-000000%40eu-central-1.amazonses.com.
