pre-built binaries for windows 8?

[צחי יעקובוביץ‎]

Hi all,

I want to use spatialite from python 3.5 64 bit.

As far as I understand, all I need to do is "conn.execute('SELECT load_extension("libspatialite-4.dll")')"

but I can not find the DLL.

In "/gaia-sins/windows-bin-amd64" there are many windows downloads, but it seems all of them are *.exe files, and not the required dll.

where can I find a pre-built dll ?

Thanks, Tzahi

[Brad Hards]

On Sat, 3 Oct 2015 03:44:28 PM צחי יעקובוביץ wrote:
> but I can not find the DLL.
> In "/gaia-sins/windows-bin-amd64" there are many windows downloads, but it
> seems all of them are *.exe files, and not the required dll.

I assume you mean http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/

In that directory, there is a mod_spatialite entry. That has the dll and the
dependencies.

Brad

[a.fu...@lqt.it]

On Sat, 3 Oct 2015 15:44:28 -0700 (PDT), צחי יעקובוביץ wrote:
> Hi all,
> I want to use spatialite from python 3.5 64 bit.
> As far as I understand, all I need to do is "conn.execute('SELECT
> load_extension("libspatialite-4.dll")')"
>

Hi Tzahi,

this is no longer valid when using the more recent versions of
spatialite; now the expected syntax is:

SELECT load_extension('mod_spatialite')

please check the current documentation for more details:

https://www.gaia-gis.it/fossil/libspatialite/wiki?name=mod_spatialite

> but I can not find the DLL.
> In "/gaia-sins/windows-bin-amd64" there are many windows downloads,
> but it seems all of them are *.exe files, and not the required dll.
>
> where can I find a pre-built dll ?
>

http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/mod_spatialite-4.3.0a-win-amd64.7z

bye Sandro

[צחי יעקובוביץ‎]

Hi Sandro and Brad,

Thanks a lot for your help.

I downloaded the amd64 version.

 sqlite3  loaded the extension with no complaints.

in Python 3.5, sqlite version is 3.8.11.

I tried in python:

import sqlite3

conn = sqlite3.connect('d:\\sqlite_data\\test.db')

conn.enable_load_extension(True)

conn.execute("SELECT load_extension('mod_spatialite')")

 

I get the following error:

sqlite3.OperationalError: A dynamic link library (DLL) initialization routine failed.

Thanks in advance,

Tzahi