Django 3.1+: (fields.E180) SQLite does not support JSONFields

Question

I have created a Django project with the new JSONField announced in Django 3.1, which supports all databases.

I have successfully used this field on a linux machine, but running python manage.py migrate with the same project on Windows fails with the following message:

(fields.E180) SQLite does not support JSONFields.

The same versions of Python and Django are used in both PCs.

Udi · Answer 1 · 2020-08-04T10:15:05.210

23

For using JSONField with Django 3.1+ and sqlite, the JSON1 sqlite extension must be installed.

To enable JSON1 on sqlite follow the instructions on Django's wiki: https://code.djangoproject.com/wiki/JSON1Extension.

Instructions for Windows:

Check your python installation - is it 32bit or 64bit? run: python -c "import platform;print(platform.architecture()[0])"
Download the precompiled DLL that matches your Python installation (32-bit or 64-bit).
Locate your Python installation. By default, it should be in %localappdata%\Programs\Python\PythonXX, where XX is the Python version. For example, it's located in C:\Users\<username>\AppData\Local\Programs\Python\Python37. 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.

edited Aug 04 '20 at 10:15

answered Jun 29 '20 at 11:49

Udi

29,222
9
96
129

1

What can we do if we want to just store json as string? This is a massive burden just for development. – Cristiano Coelho Aug 07 '20 at 17:12
Actually it should take about one minute to follow the instructions above and you get an amazing jsonfield. You can use a textfileld or find another implementation for a jsonfield - there are a few of them available – Udi Aug 07 '20 at 19:10
1

You were right, install instructions were quite simple, and in fact it was just Windows the one that required some extra setup. – Cristiano Coelho Aug 10 '20 at 15:20
It does not work for me on windows 10. I have replace dll but still getting the same error. Any idea ? – Shahid Malik Apr 04 '21 at 00:12
It does not work for me on windows 10. I have replace dll but still getting the same error. Any idea ? – Shahid Malik Apr 04 '21 at 00:14
This instructions actually worked just fine for me. – Fernando Soares Jul 18 '22 at 13:17
It actually works and took a little time. – Decoy Jan 25 '23 at 04:54

Django 3.1+: (fields.E180) SQLite does not support JSONFields

1 Answers1