[QGIS-it-user] [QGIS-Developer] QGIS and spatialite

FYI su Sptalialite

-------- Forwarded Message --------
Subject: Re: [QGIS-Developer] QGIS and spatialite
Date: Mon, 18 May 2020 14:38:05 +0200
From: Even Rouault <even.rouault@spatialys.com>
To: qgis-developer@lists.osgeo.org

Andreas,

I am struggling with libspatialite. What libspatialite versions are you

guys using? I am trying to compile libspatialite-4.3.0a, but it

complains about not finding "proj_api.h" (although this file is

available at /usr/local/include). I tried both with proj-6.3.2 and

proj-7.0.1. libspatialite-4.3.0a isn't happy with either proj version.

For 4.3.0a:

CFLAGS="-DACCEPT_USE_OF_DEPRECATED_PROJ_API_H -O2 should help:

https://github.com/OSGeo/gdal/blob/master/gdal/docker/alpine-normal/Dockerfile#L248

You can also build against the development repository of Spatialite:

https://github.com/OSGeo/gdal/blob/master/gdal/ci/travis/ubuntu_1804/install.sh#L27

(you could probably drop the "fossil update 90180e065d" which must have
been a

workaround against a regression, and the other peculiarities), so mostly:

fossil clone https://www.gaia-gis.it/fossil/libspatialite
libspatialite.fossil

mkdir sl

cd sl

fossil open ../libspatialite.fossil

./configure [...]

I noticed that there

hadn't been a lot of activity with this library in the past months/years.

Yes, I've tried to maintain a communication channel with the developper,
but with

moderate success only. The development is not abandoned, but only at a
rather slow

pace.

On a related question: could I build QGIS without libspatialite? I

failed to do so, but maybe there are some tricks.

I don't think you can without some surgery in the code base.

FWIW, the WFS provider depends on it for caching (could potentially be
replaced by

something else)

Even

--

Spatialys - Geospatial professional services

http://www.spatialys.com