GeoDjango application using SpatiaLite database

Question

I want to create a simple GeoDjango app with SpatiaLite database but I have this error at migrate:

django.core.exceptions.ImproperlyConfigured: Unable to load the SpatiaLite library extensio`.

Here the code :

settings.py

INSTALLED_APPS = [
    ..................
    'django.contrib.gis',
     .............
]

DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.spatialite',
        'NAME': os.path.join(BASE_DIR, 'basetest.sqlite3'),
    }
}

Where I went wrong?

Answer 1

You need to install the SQLite spatial extension SpatiaLite:

• on Debian-based GNU/Linux distributions (es: Debian, Ubuntu, …):

   $ apt install libsqlite3-mod-spatialite
  

• on macOS using Hoembrew:

    $ brew install spatialite-tools
  

You can find complete example of a map with Geodjango and Spatialite in this article: Maps with Django (part 1): GeoDjango, SpatiaLite and Leaflet