AW: [Qgis-developer] SpatiaLite data provider

Hugentobler Marco marco.hugentobler at
Fri Mar 6 01:49:52 EST 2009

Hi Alessandro

Glad to hear you made good progress. The PSC decided to give you svn write access so Gary will give you the details (login/pw) soon (if not already done).

However, we should discuss the minimum version issues of sqlite3 and proj before you proceed with committing. Would it be an option to add a cmake test for the sqlite version that is available, create a cmake variable and build the sqlite provider if it is set? You would need to consider that in providers/CMakeLists.txt and probably in the opening dialog.


>b) my Ubuntu 8.04.1 ships on /usr/lib and /usr/include
>   an unbelievably obsolescent
>c) QGis ships an internal sqlite3, but this too is
>   too old to be useful.

-----Ursprüngliche Nachricht-----
Von: qgis-developer-bounces at im Auftrag von Alessandro Furieri
Gesendet: Do 05.03.2009 21:23
An: Gary Sherman
Cc: qgis-developer at
Betreff: Re: [Qgis-developer] SpatiaLite data provider
Hi Gary,

I've completed the integration of my SpatiaLite
data provider in QGis 1.1 [SVN rev.10264]

I've done a quite extensive testing; anything seems
to be reasonably stable.

If you wish to review the patches I've applied you
can find all the sources at:

[please note: the latest version for QGis 1.1 is at
the bottom of the page]

You'll find some useful explanation at:


I noticed there is some annoying issue in the CMake
build system (at least, I wasn't able to find an
elegant and robust solution ...)

The question arises from and
related headers:

a) SpatiaLite absolutely needs a recent version
   supporting the R*Tree spatial index (v.3.6.0
   or later; current SQLite is v.3.6.11)

b) my Ubuntu 8.04.1 ships on /usr/lib and /usr/include
   an unbelievably obsolescent

c) QGis ships an internal sqlite3, but this too is
   too old to be useful.

I found some problem with PROJ.4 as well (SpatiaLite
uses the latest v.4.6.1), but this one doesn't seems
to be a critical issue, because the proj APIs are

Any suggestion about this will be strongly appreciate.
Best regards,
Sandro Furieri

Gary Sherman ha scritto:
> On Feb 26, 2009, at 5:51 AM, a.furieri at wrote:
>> Hi all,
>> I'm the developer of SpatiaLite, a lightweighted
>> spatial DBMS based on SQLite.
>> Can you kindky enable me to access the SVN,
>> so that I can contribute the SpatiaLite
>> data provider for QGis I've already developed ?
>> thanks very much,
>> Sandro Furieri
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at
> Can you provide a patch against the current trunk so the provider can 
> be reviewed?
> -gary
> -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
> Gary Sherman
> Chair, QGIS Project Steering Committee
> -Micro Resources:
>   *Geospatial Hosting
>   *Web Site Hosting
> -Desktop GIS Book:
>   *
> "We work virtually everywhere"
> -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
> ------------------------------------------------------------------------
> No virus found in this incoming message.
> Checked by AVG - 
> Version: 8.0.237 / Virus Database: 270.11.5/1978 - Release Date: 03/01/09 07:04:00
Qgis-developer mailing list
Qgis-developer at

More information about the Qgis-developer mailing list