[GIS] integrating spatialite and php (sqlite3) on windows platform

PHPspatialitesqlite

anyone can give me an explanation about how to integrate spatialite with php(sqlite3)-windows platforms.

I have tried to refer from this link http://www.gaia-gis.it/spatialite-2.4.0-4/spatialite-cookbook/html/php.html

But I do not understand is why the error message appears as follows.

"Warning SQLite3::loadextension(), Not supported in multithreaded Web Servers"

i use libspatialite-2.dll

Best Answer

The message is explicit. Your server settings does not support loading extension from script like so :

$db->loadExtension('libspatialite.so');

See if you could load it directly from the php.ini

Related Solutions

Spatialite ODBC – Loading Spatialite Extension via SQLite3 ODBC Driver

I did the following:

Put the DLLs in a different spot (NOT system32) - in my case c:\spatialite\bin. Note that you need more than just libspatialite - there are supporting DLLs that need to also be there.
Put the entire path in the extension box, not just the name.
Commence with great joy

Oddly enough I had already done the first step - so just adding c:\spatialite\bin to my odbc dll extension is all I needed to do. It's the little things sometimes. I also had already added that location to my PATH environmental variable - but I did a quick test and it doesn't appear to be a requirement.

I'm GUESSING that perhaps it has something to do with it looking in system32 but being a 64bit driver. I'm just guessing on that - I'm still on step #3.

Python – Problem Loading SpatiaLite Extension with SQLite3 Python Connector

In native (out of the box) Python installations extensions are disabled within sqlite3. Unfortunately this means that you will need to build the base pysqlite2 library manually and use that instead.

On Windows this will mean that you need a C compiler (Visual Studio comes with one - I've used Visual Studio 2010 for this before). However (with massive props) Christoph Gholke's Unofficial Windows Binaries for Python Extension Packages provides a pysqlite2 download that does have the extensions enabled by default. I haven't tested these binaries with 3rd party extensions though, so for a guarantee I'd try building it myself.

First download the pysqlite2 package.
In setup.cfg comment out the define=SQLITE_OMIT_LOAD_EXTENSION so the config looks like:

[build_ext] #define= #include_dirs=/usr/local/include #library_dirs=/usr/local/lib libraries=sqlite3 #define=SQLITE_OMIT_LOAD_EXTENSION

Build from scratch with python setup.py build_static install. This will download and build the sqlite3 libraries for you.

We can then test this in Python with the following:

import pysqlite2.dbapi2 as sqlite3 #alias over the top of the standard sqlite3 module

conn = sqlite3.connection(":memory:")

### NOTE: Don't use the following line with Christolph Gholke's build - extensions are enabled by default
conn.enable_load_extension(True)

#Now test extensions are working by trying the inbuilt rtree extension
conn.execute("CREATE VIRTUAL TABLE testrtree USING rtree(id,minX,maxX,minY,maxY);")

#then you can try loading spatialite
conn.execute("select load_extension('libspatialite-4.dll')")

Assuming that's all worked with no errors thrown then you should be good to go using spatialite in Python.

Best Answer

Related Solutions

Spatialite ODBC – Loading Spatialite Extension via SQLite3 ODBC Driver

Python – Problem Loading SpatiaLite Extension with SQLite3 Python Connector

Related Question