AW: [Qgis-developer] SpatiaLite data provider

[Hugentobler Marco]

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.

Regards,
Marco

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






-----Ursprüngliche Nachricht-----
Von: qgis-developer-bounces at lists.osgeo.org im Auftrag von Alessandro Furieri
Gesendet: Do 05.03.2009 21:23
An: Gary Sherman
Cc: qgis-developer at lists.osgeo.org
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:

http://www.gaia-gis.it/QGisJanus/

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

You'll find some useful explanation at:
http://www.gaia-gis.it/QGisJanus/SpatiaLite_QGis.pdf

--------

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 libsqlite3.so 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 libsqlite3.so

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
stable.

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 lqt.it 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 lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> 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: http://mrcc.com
>   *Geospatial Hosting
>   *Web Site Hosting
> -Desktop GIS Book:
>   *http://desktopgisbook.com
> "We work virtually everywhere"
> -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
>
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> 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 lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer