/directus-hook-sqlite-spatialite

A simple Directus hook to load the SpatialLite extension into SQLite on each connection

Primary LanguageJavaScriptMIT LicenseMIT

Spatialite Extension

If you want to use GEO functions inside directus and are using SQLite as your database backend, you need the SpatiaLite extension for SQLite.

screenshot

This Directus extension will load the module into the database (it will add it to every connection, that is the way how it works for SQLite).

Note that your Directus backend will need the library to be installed. If you are using the official docker image you can easily build your own image with the library included.

FROM directus/directus:10.12.0

## Install SQLite SpatiaLite: extend the SQLite core to support fully fledged Spatial SQL
## capabilities.
## https://pkgs.alpinelinux.org/package/edge/community/x86/libspatialite

USER root
RUN <<EOF
  apk --no-cache add libspatialite
  ln -s mod_spatialite.so.8 /usr/lib/mod_spatialite
EOF
USER node

Some additional notes

This extension is inspired on the links in the list below.