<div dir="ltr"><div>Hi devs,<br><br><br>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. :(<br><br>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.).<br><br>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?</div><div><br></div><div><br>Regards, <br><br>Germán<br>---------------------<br>[1] <a style="color:rgb(52,101,164)" href="https://issues.qgis.org/issues/16720">https://issues.qgis.org/issues/16720</a><br>[2] <a style="color:rgb(52,101,164)" href="https://lists.osgeo.org/pipermail/qgis-developer/2017-September/049776.html">https://lists.osgeo.org/pipermail/qgis-developer/2017-September/049776.html</a><br>[3] <a style="color:rgb(52,101,164)" href="https://groups.google.com/d/msg/spatialite-users/o0jUwMUqx_g/OEat2JTUAAAJ">https://groups.google.com/d/msg/spatialite-users/o0jUwMUqx_g/OEat2JTUAAAJ</a><br>[4] <a style="color:rgb(52,101,164)" href="https://github.com/qgis/QGIS/blob/master/python/utils.py#L602-L609">https://github.com/qgis/QGIS/blob/master/python/utils.py#L602-L609</a><br></div><div><br></div><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div>-----------<br></div><div>   |\__  <br>(:>__)(<br>   |/    <br>Soluciones Geoinformáticas Libres                            <br><a href="http://geotux.tuxfamily.org/" target="_blank">http://geotux.tuxfamily.org/</a><br><a href="http://twitter.com/GeoTux2" target="_blank">http://twitter.com/GeoTux2</a></div><div><a href="http://about.me/germancarrillo" target="_blank">http://about.me/germancarrillo</a><br></div><div><div><br></div><div><a href="http://gis.stackexchange.com/users/4972/germ%c3%a1n-carrillo" target="_blank"><img src="http://gis.stackexchange.com/users/flair/4972.png"></a></div></div></div></div></div></div></div>
</div>