<div dir="ltr">+1 to use sqlite3+loadExtension.... tnx to rise up the problem.</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature">Luigi Pirelli<br><br>**************************************************************************************************<br>* Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com<br>* LinkedIn: <a href="https://www.linkedin.com/in/luigipirelli" target="_blank">https://www.linkedin.com/in/luigipirelli</a><br>* Stackexchange: <a href="http://gis.stackexchange.com/users/19667/luigi-pirelli" target="_blank">http://gis.stackexchange.com/users/19667/luigi-pirelli</a><br>* GitHub: <a href="https://github.com/luipir" target="_blank">https://github.com/luipir</a><br>* Mastering QGIS 2nd Edition:<br>* <a href="https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition" target="_blank">https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition</a><br>**************************************************************************************************</div></div>
<br><div class="gmail_quote">On 24 October 2017 at 00:02, Germán Carrillo <span dir="ltr"><<a href="mailto:carrillo.german@gmail.com" target="_blank">carrillo.german@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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(<wbr>). 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" target="_blank">https://issues.qgis.org/<wbr>issues/16720</a><br>[2] <a style="color:rgb(52,101,164)" href="https://lists.osgeo.org/pipermail/qgis-developer/2017-September/049776.html" target="_blank">https://lists.osgeo.org/<wbr>pipermail/qgis-developer/2017-<wbr>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" target="_blank">https://groups.google.com/d/<wbr>msg/spatialite-users/<wbr>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" target="_blank">https://github.com/qgis/QGIS/<wbr>blob/master/python/utils.py#<wbr>L602-L609</a><span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div><br></div><br clear="all"><div><br></div>-- <br><div class="m_-8867190521261511406gmail_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></a></div></div></div></div></div></div></div>
</font></span></div>
<br>______________________________<wbr>_________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-<wbr>developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-<wbr>developer</a><br></blockquote></div><br></div>