+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 <[email protected]> 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 > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
