<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">The 3MB size is the size of an empty DB
spatialite .<br>
A DB emty is 3MB size .<br>
<br>
A DBspatialite with 1 single dataset of 10MB is<br>
<br>
3MB +10MB = 13MB.<br>
<br>
A DBspatialite with 3 dataset everyone of 10MB is<br>
<br>
3MB + 10MB +10MB + 10MB = 33MB.<br>
<br>
Also, AFAIK the goal of Luigi is storing in the spatialite the SLD
finalized to rendering the same dataset stored in the spatialite,
<br>
not to store SLD for general usage.<br>
<br>
Regards,<br>
<br>
Andrea.<br>
<br>
On 05/02/2014 22:24, Etienne Tourigny wrote:<br>
</div>
<blockquote
cite="mid:CA+TxYvP=bsSMNXZ_S_G=fnDZqDkt5PpzsRE5tjah8v+kpZS8PQ@mail.gmail.com"
type="cite">
<div dir="ltr">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?</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
On Wed, Feb 5, 2014 at 10:18 AM, Gino Pirelli <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:luipir@gmail.com"
target="_blank">luipir@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div dir="ltr">Hi,
<div><br>
</div>
<div>I'm developing a new feature to save SLD and ui in
Spatialite provider in the same way this function is
available for postgres.</div>
<div><br>
</div>
<div>this function developed for Faunalia is funded by
ARPA Piemonte<br>
</div>
<div>fork is available at: <a moz-do-not-send="true"
href="https://github.com/luipir/QGIS/tree/spatialite-savestyle"
target="_blank">https://github.com/luipir/QGIS/tree/spatialite-savestyle</a></div>
<div>and actual modification are localized in this
commit: f058bea1fe51116b8231eb5c1ca4faee485c38b2</div>
<div><br>
</div>
<div>there are some question about how to develop it and
are related how to manage XML in a sqlite/spatialite
table.</div>
<div><br>
</div>
<div>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])</div>
<div>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.</div>
<div><br>
</div>
<div>so the question is... sqlite blob or spatialite
xmlbob?</div>
<div><br>
</div>
<div>Blob type can't allow XML parsing using SQL queries<br>
</div>
<div>XmlBlob allows this (using libxml2)</div>
<div><br>
</div>
<div>Blob type is sqlite native type</div>
<div>XmlBlob can be used only with SL 4.1></div>
<div><br>
</div>
<div>My preference is to use native data type Blob.
What's you opinion about blob/ xmlblob or whatever</div>
<div><br>
</div>
<div>regards,</div>
<div>
<div>
<div dir="ltr"><br>
Luigi Pirelli (<a moz-do-not-send="true"
href="mailto:luigi.pirelli@faunalia.it"
target="_blank">luigi.pirelli@faunalia.it</a> - <a
moz-do-not-send="true"
href="mailto:luipir@gmail.com" target="_blank">luipir@gmail.com</a>)</div>
</div>
</div>
<div><br>
</div>
<div>[1] <a moz-do-not-send="true"
href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=XmlBlob-intro"
target="_blank">https://www.gaia-gis.it/fossil/libspatialite/wiki?name=XmlBlob-intro</a></div>
<div><br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a moz-do-not-send="true"
href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-developer"
target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-developer mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a></pre>
</blockquote>
<br>
</body>
</html>