django-jsonfield-backport 0.1.1

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 and 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 the JSON1 extension

All database backends are tested with the latest versions of their drivers. SQLite is also tested on GitHub Actions’ latest macOS and Windows virtual environments.

Installation

Use pip or your preferred dependency management tool.

$ pip install django-jsonfield-backport

Usage

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.

License

This package is licensed under the BSD 3-Clause License.