[Qgis-developer] SpatiaLite data provider

[Alex Mandel]

I found it perfectly safe on Ubuntu to use the Jaunty sqlite3 packages
at least on Intrepid. Haven't tried on 8.04 but looking at the
dependencies it should work too.

We should probably up the internal version though also.

Alex

Alessandro Furieri wrote:
> 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