[Qgis-developer] New feature: RFC saving style and ui in Spatialite

Etienne Tourigny etourigny.dev at gmail.com
Wed Feb 5 13:24:22 PST 2014


Saving style as spatialite files would probably cause a significant file
size overhead - don't all spatialite files take at least 3MB for the SRS
tables?


On Wed, Feb 5, 2014 at 10:18 AM, Gino Pirelli <luipir at gmail.com> wrote:

> Hi,
>
> I'm developing a new feature to save SLD and ui in Spatialite provider in
> the same way this function is available for postgres.
>
> this function developed for Faunalia is funded by ARPA Piemonte
> fork is available at:
> https://github.com/luipir/QGIS/tree/spatialite-savestyle
> and actual modification are localized in this
> commit: f058bea1fe51116b8231eb5c1ca4faee485c38b2
>
> there are some question about how to develop it and are related how to
> manage XML in a sqlite/spatialite table.
>
> this code derive by the postgres provider code where QML and UI xmls are
> recorded in a XML column. XML is a postgres type. This type is not
> available in SQlite but it's available in SL 4.1> (called XmlBlob [1])
> In this preliminary commit XML is saved in a text column, but saving XML
> as a blog (blob type in sqlite or XmlBlob in SL) have the advantage to
> avoid all encoding problems.
>
> so the question is... sqlite blob or spatialite xmlbob?
>
> Blob type can't allow XML parsing using SQL queries
> XmlBlob allows this (using libxml2)
>
> Blob type is sqlite native type
> XmlBlob can be used only with SL 4.1>
>
> My preference is to use native data type Blob. What's you opinion about
> blob/ xmlblob or whatever
>
> regards,
>
> Luigi Pirelli (luigi.pirelli at faunalia.it - luipir at gmail.com)
>
> [1] https://www.gaia-gis.it/fossil/libspatialite/wiki?name=XmlBlob-intro
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140205/8c21f5a0/attachment.html>


More information about the Qgis-developer mailing list