Re: [Django] #12990: Add JSONField model field

30 views
Skip to first unread message

Django

unread,
Oct 4, 2018, 12:55:13 PM10/4/18
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Simon Charette):

* status: closed => new
* resolution: fixed =>


Comment:

I believe the next step is to come up with a compatibility table of all
supported database types and which lookups we want to support.

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:50>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Oct 20, 2018, 8:02:00 AM10/20/18
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by felixxm):

* cc: felixxm (added)


--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:51>

Django

unread,
May 13, 2019, 7:57:21 PM5/13/19
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by sage):

* owner: nobody => sage
* status: new => assigned


Comment:

I will be working on this ticket during Google Summer of Code 2019.

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:52>

Django

unread,
Jun 11, 2019, 12:42:47 AM6/11/19
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 1
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by sage):

* needs_better_patch: 0 => 1
* has_patch: 0 => 1
* needs_docs: 0 => 1


Comment:

[https://github.com/django/django/pull/11452 PR].

Please note that it's still a draft and I haven't implemented custom
lookups and transforms. More info on the PR's description.

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:53>

Django

unread,
Jul 29, 2019, 7:52:02 AM7/29/19
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by sage):

* needs_better_patch: 1 => 0
* needs_docs: 1 => 0


Comment:

The implementation is pretty much complete now, and docs have also been
added.

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:54>

Django

unread,
Aug 14, 2019, 7:01:55 AM8/14/19
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Giacomo Graziosi):

* cc: Giacomo Graziosi (added)


--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:55>

Django

unread,
Oct 17, 2019, 6:33:06 AM10/17/19
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"6f82df69efa372fb4bddf272fff577850a09f1dc" 6f82df6]:
{{{
#!CommitTicketReference repository=""
revision="6f82df69efa372fb4bddf272fff577850a09f1dc"
Refs #12990 -- Moved CheckFieldDefaultMixin to the
django.db.models.fields.mixins.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:56>

Django

unread,
Jan 30, 2020, 9:51:01 AM1/30/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by sage):

[https://github.com/django/django/pull/12392 PR].

Moved to a fresh one.

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:57>

Django

unread,
Apr 1, 2020, 4:56:10 AM4/1/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by GitHub <noreply@…>):

In [changeset:"5c24c16e68868b33ea0bb30173403da51a078d2e" 5c24c16e]:
{{{
#!CommitTicketReference repository=""
revision="5c24c16e68868b33ea0bb30173403da51a078d2e"
Refs #12990 -- Moved PostgresSimpleLookup to the
django.db.models.lookups.PostgresOperatorLookup.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:58>

Django

unread,
May 7, 2020, 7:08:25 AM5/7/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by felixxm):

* stage: Accepted => Ready for checkin


--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:59>

Django

unread,
May 8, 2020, 1:51:59 AM5/8/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: closed

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed

Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

* status: assigned => closed
* resolution: => fixed


Comment:

In [changeset:"6789ded0a6ab797f0dcdfa6ad5d1cfa46e23abcd" 6789ded0]:
{{{
#!CommitTicketReference repository=""
revision="6789ded0a6ab797f0dcdfa6ad5d1cfa46e23abcd"
Fixed #12990, Refs #27694 -- Added JSONField model field.

Thanks to Adam Johnson, Carlton Gibson, Mariusz Felisiak, and Raphael
Michel for mentoring this Google Summer of Code 2019 project and
everyone else who helped with the patch.

Special thanks to Mads Jensen, Nick Pope, and Simon Charette for
extensive reviews.

Co-authored-by: Mariusz Felisiak <felisiak...@gmail.com>
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:61>

Django

unread,
May 8, 2020, 1:51:59 AM5/8/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: assigned

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"f97f71f59249f1fbeebe84d4fc858d70fc456f7d" f97f71f5]:
{{{
#!CommitTicketReference repository=""
revision="f97f71f59249f1fbeebe84d4fc858d70fc456f7d"
Refs #12990 -- Bumped mysqlclient requirement to >= 1.4.0.

MySQLdb.constants.FIELD_TYPE.JSON was added in mysqlclient 1.4.0rc2.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:60>

Django

unread,
May 18, 2020, 2:12:47 AM5/18/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: closed

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed

Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by GitHub <noreply@…>):

In [changeset:"f59a2b730685fc62c5cb44101f54faf8921d9bc7" f59a2b73]:
{{{
#!CommitTicketReference repository=""
revision="f59a2b730685fc62c5cb44101f54faf8921d9bc7"
Refs #12990 -- Added DatabaseFeatures.has_json_operators.

CockroachDB also has them.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:62>

Django

unread,
May 18, 2020, 2:13:56 AM5/18/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"5480fab290655682db7fc12c087675df43115a01" 5480fab2]:
{{{
#!CommitTicketReference repository=""
revision="5480fab290655682db7fc12c087675df43115a01"
[3.1.x] Refs #12990 -- Added DatabaseFeatures.has_json_operators.

CockroachDB also has them.
Backport of f59a2b730685fc62c5cb44101f54faf8921d9bc7 from master
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:63>

Django

unread,
Jul 3, 2020, 7:23:52 AM7/3/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"5d4b9c1cab03f0d057f0c7751862df0302c65cf9" 5d4b9c1c]:
{{{
#!CommitTicketReference repository=""
revision="5d4b9c1cab03f0d057f0c7751862df0302c65cf9"
Refs #12990 -- Added example to JSONField release notes.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:64>

Django

unread,
Jul 3, 2020, 7:24:12 AM7/3/20
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"7598ba01aa2b0b48ac006aea6d218f77eb949061" 7598ba01]:
{{{
#!CommitTicketReference repository=""
revision="7598ba01aa2b0b48ac006aea6d218f77eb949061"
[3.1.x] Refs #12990 -- Added example to JSONField release notes.

Backport of 5d4b9c1cab03f0d057f0c7751862df0302c65cf9 from master
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:65>

Django

unread,
Jan 14, 2021, 2:12:18 PM1/14/21
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"7cb5712edc158396c9d4fbf1ecf17794d9a128b3" 7cb5712]:
{{{
#!CommitTicketReference repository=""
revision="7cb5712edc158396c9d4fbf1ecf17794d9a128b3"
Refs #12990 -- Removed django.contrib.postgres.fields.JSONField per
deprecation timeline.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:66>

Django

unread,
Jan 14, 2021, 2:12:18 PM1/14/21
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"2dd6a83d2d7c61321ac4a9b10fbf3c379cb305c3" 2dd6a83]:
{{{
#!CommitTicketReference repository=""
revision="2dd6a83d2d7c61321ac4a9b10fbf3c379cb305c3"
Refs #12990 -- Removed django.contrib.postgres.forms.JSONField per
deprecation timeline.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:68>

Django

unread,
Jan 14, 2021, 2:12:19 PM1/14/21
to django-...@googlegroups.com
#12990: Add JSONField model field
-------------------------------------+-------------------------------------
Reporter: paltman | Owner: sage
Type: New feature | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"8fdb5a656a35dc9beef4cf2b79a782068263c7ec" 8fdb5a65]:
{{{
#!CommitTicketReference repository=""
revision="8fdb5a656a35dc9beef4cf2b79a782068263c7ec"
Refs #12990 -- Removed
django.contrib.postgres.fields.jsonb.KeyTransform/KeyTextTransform.

Per deprecation timeline.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/12990#comment:67>

Reply all
Reply to author
Forward
0 new messages