[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

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