[QGIS-Developer] Is PySpatiaLite needed for QGIS v3?

[Germán Carrillo]

Hi devs,


there are known issues using pyspatialite that lead to QGIS v3 crashes (see
[1] and [2]). In fact, using DB Manager these days to explore a SpatiaLite
database leads to a QGIS crash on Windows. :(

The easy fix for such issue could be to avoid pyspatialite (see why [3])
and use sqlite3 instead, loading the SpatiaLite module (see [4]). Avoiding
pyspatialite is possible adjusting qgis.utils.spatialite_connect().
However, loading the SpatiaLite module doesn't seem to be simple depending
on the Operating System. I've attempted to do so on Windows with no success
(several combinations, giving full path to the module, etc.).

Does anybody know how to load the SpatiaLite module for sqlite3 on Windows?
Apart from that, is there any problem if QGIS v3 switches to sqlite3 for
SpatiaLite connections?


Regards,

Germán
---------------------
[1] https://issues.qgis.org/issues/16720
[2]
https://lists.osgeo.org/pipermail/qgis-developer/2017-September/049776.html
[3]
https://groups.google.com/d/msg/spatialite-users/o0jUwMUqx_g/OEat2JTUAAAJ
[4] https://github.com/qgis/QGIS/blob/master/python/utils.py#L602-L609



-- 
-----------
   |\__
(:>__)(
   |/
Soluciones Geoinformáticas Libres
http://geotux.tuxfamily.org/
http://twitter.com/GeoTux2
http://about.me/germancarrillo

<http://gis.stackexchange.com/users/4972/germ%c3%a1n-carrillo>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20171023/353e2439/attachment.html>