<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">Hi,</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">For some times some people are reporting that plugins using pyspatialite are not working anymore with the KyngChaos packaging for OSX (2.14 or 2.18)</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">The error is usually:</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">OperationalError('no such module: VirtualSpatialIndex',)</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">when trying to référence SpatialIndex in spatial requests.</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">After investigation it appears that errors occurs when trying to use spatialite functions…</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">The fact is, when using pyspatialite directly from python: the spatialite extension is not loaded.</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">cur.execute('SELECT spatialite_version()')</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><blockquote type="cite" style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">OperationalError: no such function: spatialite_version<br class=""></blockquote><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">and so on for any SELECT involving spatialite functions.</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">This can be explained easily has the pyspatialite python package is only a link to the pysqlite2 python package, and thus, do not load the the spatialite module. </span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">Furthemore loading extension is disabled in the KyngChaos sqlite3 package, so we are stuck in that the pyspatialite provided by KyngChaos is useless as standalone library and do not enable plugins to make direct calls to spatialite.</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">Is there any reason for this situation or this should be considered as a bug ?? </span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">Actually, the native OSX sqlite3 python binding do not enable leading extensions, this was preventing using spatialite from python. This constraint has been removed recently in Macport, which now enables to use spatialite with python without relying on pyspatialite.</span><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class="">David.</span><div class=""><span style="font-family: Roboto, 'Helvetica Neue', Helvetica, Arial, sans-serif;" class=""><br class=""></span></div></body></html>