(fields.E180) SQLite does not support JSONFields.

Enabling JSON1 extension on SQLite

&gt;>> import sqlite3
>>> conn = sqlite3.connect(':memory:')
>>> cursor = conn.cursor()
>>> cursor.execute('SELECT JSON('{"a": "b"}')')

If the query doesn‘t throw any error s, then the JSON1 extension is already enabled. Otherwise, follow the in struct ions below a ccording to your operating system to set it up correctly.

On most m ajor Linux distributions, the JSON1 extension is included in their SQLite and/or Python packages and enabled by default. If that’s not the case on your installation, then do the follo wing:

Download the SQLite amalgamation, with or without the configuration script.
Extract the source code archive and enter the directory of the result.
Compile the source code using the -DSQLITE_ENABLE_JSON1 flag to enable the JSON1 extension. For example:
```
gcc -DSQLITE_ENABLE_JSON1 -c -fPIC sqlite3.c
```
To enable other extensions, see the compilation instructions.

Create a shared library. For example:

gcc -shared -o libsqlite3.so -fPIC sqlite3.o -ldl -lpthread

Place the resulting file (lib sqlite3.so) in a desired directory, e.g. /usr/lib/sqlite3/.
Set the LD_PRELOAD environment variable to use your com piled SQLite every time you run Django. For example:
```
export LD_PRELOAD=/usr/lib/sqlite3/libsqlite3.so
```
Now, the JSON1 extension should be re ady to be used in Python and Django.

As of Python 3.7, the official Python installer on macOS alre ady includes the JSON1 extension by default. If you’re using an ear lier version of Python or unofficial installers, you can follow the instructions for Linux above, but inste ad of setting the LD_PRELOAD environment variable, use DYLD_LIBRARY_PATH. For example:

export DYLD_LIBRARY_PATH=/usr/lib/sqlite3

As of Python 3.9, the off icial Python installer on Windows alre ady includes the JSON1 extension by default. If you’re using an earl ier version of Python or unoff icial installers, you can do the following:

Download the precompiled DLL that match es your Python installation (32-bit or 64-bit).
Locate your Python installation. By default, it should be in %local app data%ProgramsPythonPythonXX, where XX is the Python version. For example, it’s located in C:Users<username>Ap pDataLocalProgramsPythonPython37. If you added Python installation directory to your PATH environment variable, you can run the command where python on a command prompt to locate it.
Enter the DLLs directory in your Python installation.
Rename (or delete) sqlite3.dll inside the DLLs directory.
Extract sqlite3.dll from the downloaded DLL archive and put it in the DLLs directory.
Now, the JSON1 extension should be ready to be used in Python and Django.