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

Gino Pirelli luipir at gmail.com
Wed Feb 5 04:18:28 PST 2014


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:
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


Luigi Pirelli (luigi.pirelli at faunalia.it - luipir at gmail.com)

[1] https://www.gaia-gis.it/fossil/libspatialite/wiki?name=XmlBlob-intro
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140205/81dd3ee6/attachment-0001.html>

More information about the Qgis-developer mailing list