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

Luigi Pirelli luipir at gmail.com
Tue Oct 24 00:22:50 PDT 2017


+1 to use sqlite3+loadExtension.... tnx to rise up the problem.

Luigi Pirelli

**************************************************************************************************
* Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Mastering QGIS 2nd Edition:
*
https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
**************************************************************************************************

On 24 October 2017 at 00:02, Germán Carrillo <carrillo.german at gmail.com>
wrote:

> 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>
>
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20171024/cbe4ca34/attachment.html>


More information about the QGIS-Developer mailing list