Backport of the cross-DB JSONField model and form fields from Django 3.1.
Project description
Backport of the cross-DB JSONField model and form fields from Django 3.1.
from django.db import models
from django_jsonfield_backport.models import JSONField
class ContactInfo(models.Model):
data = JSONField()
ContactInfo.objects.create(data={
'name': 'John',
'cities': ['London', 'Cambridge'],
'pets': {'dogs': ['Rufus', 'Meg']},
})
ContactInfo.objects.filter(
data__name='John',
data__pets__has_key='dogs',
data__cities__contains='London',
).delete()Features
Most features of the JSONField model and form fields from Django 3.1 are supported.
MariaDB, MySQL, Oracle, PostgreSQL, and SQLite support.
JSONField lookups and transforms support.
Custom encoder and decoder support.
Due to limited access to Django’s APIs, some features are not supported.
Introspection is not supported.
On MariaDB and Oracle, Casting to JSONField must be done using the included JSONCast class.
This package is fully compatible with the JSONField from Django 3.1. That means you just need to change your imports and edit your migrations when you finally upgrade to Django 3.1. If you leave them as they are, this package will use the built-in JSONField system warnings will be raised.
Requirements
This package supports and is tested against the latest patch versions of:
Python: 3.5 (Django 2.2 only), 3.6, 3.7, 3.8, 3.9
Django: 2.2, 3.0, 3.1
MariaDB: 10.2, 10.3, 10.4, 10.5
MySQL: 5.7, 8.0
Oracle: 12.2+ (only tested against 12.2.0.1 SE)
PostgreSQL: 9.5, 10, 11, 12
SQLite: 3.9.0+ with JSON1 extension (only tested against the built-in library included in Ubuntu’s Python packages)
All database backends are tested with the latest versions of their drivers.
Installation
Use pip or your preferred dependency management tool.
$ pip install django-jsonfield-backportUsage
To use the model and form fields, import JSONField from django_jsonfield_backport.models and django_jsonfield_backport.forms, respectively.
Model field example:
from django.db import models
from django_jsonfield_backport.models import JSONField
class ContactInfo(models.Model):
data = JSONField()Form field example:
from django import forms
from django_jsonfield_backport.forms import JSONField
class ContactForm(forms.Form):
data = JSONField()JSONCast, KeyTransform, and KeyTextTransform classes are also available from django_jsonfield_backport.models.
Documentation
Since this package is a backport, the official Django 3.1 docs for models.JSONField and forms.JSONField are mostly compatible with this package.
Rationale
As of the creation of this package, JSONField implementations exist in multiple packages on PyPI:
Django: Before Django 3.1, PostgreSQL-only JSONField exists in the contrib.postgres module.
jsonfield: 1.1k stars, cross-DB support with no extended querying capabilities.
django-annoying: 787 stars, has a TextField-based JSONField with no extended querying capabilities.
Django-MySQL: 364 stars, has a MariaDB/MySQL-only JSONField with extended querying capabilities (not entirely the same as in contrib.postgres).
django-jsonfallback: 26 stars, uses JSONField from contrib.postgres and Django-MySQL before falling back to TextField-based JSONField.
django-json-field: 116 stars, TextField-based JSONField with custom encoder and decoder support with no extended querying capabilities (unmaintained).
django-jsonfield: 21 stars, cross-DB support with no extended querying capabilities.
django-jsonfield-compat: 8 stars, compatibility layer for contrib.postgres JSONField and django-jsonfield.
oracle-json-field: 2 stars, Oracle-only JSONField with extended querying capabilities (not entirely the same as in contrib.postgres).
Along with other unmaintained packages such as dj-jsonfield, vlk-django-jsonfield, linaro-django-jsonfield, jsonfield2, django-jsonfield2, django-softmachine, django-simple-jsonfield, easy_jsonfield, and django-jsonbfield.
Why create another one?
Up until the new JSONField in Django 3.1, there had been no implementation of JSONField that supports all the database backends supported by Django with more or less the same functionalities as the contrib.postgres JSONField provides.
Django’s release process does not backport new features to previous feature releases. However, the current LTS release is 2.2 which is still supported until April 2022. The next LTS release is Django 3.2 in April 2021 that happens to be the end of extended support for Django 3.1.
Some projects only use LTS releases of Django. There are also incompatibilities between Django 3.0 and 3.1. Therefore, using Django 3.1 may not be an option for some people at the moment.
Since JSONField seems to be in popular demand and that it works well as a standalone package, I decided to create a backport.
Besides, I’m the co-author of the new JSONField. ¯\_(ツ)_/¯
License
This package is licensed under the BSD 3-Clause License.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for django-jsonfield-backport-0.1.0.tar.gz
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 6fa50faa5dae2d7ecac7a6d6215dec10577e8f7571ac2af4da727ff05a604e0c |
|
| MD5 | 01a9fa9e78d88226030ce771ef907074 |
|
| BLAKE2b-256 | da1772cebbb8f23f75b64f8685ece642af9c3a53ccf9605fcb6bb1ec39d7f298 |
Hashes for django_jsonfield_backport-0.1.0-py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 1894a57cc381e7deae9768a9c525ef15e0633185b4071516e9e2ec5cd14725fa |
|
| MD5 | 443a6d6d9a9fb8d7de4655f7307a4cc4 |
|
| BLAKE2b-256 | 9b5e7b632ea83c3b250f9440014c482458fb983464b705d8f8db9024f4ef796c |
