<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Árni,<br>
<br>
There is an issue report open with some background information
regarding this topic:<br>
<a class="moz-txt-link-freetext" href="http://hub.qgis.org/issues/8923">http://hub.qgis.org/issues/8923</a><br>
<br>
Regards,<br>
Matthias<br>
<br>
<div class="moz-cite-prefix">On 04/27/2016 02:47 PM, Árni Geirsson
wrote:<br>
</div>
<blockquote
cite="mid:CALtMHXggGBw+=G_5WoQSLiFBJ--5aJmB56WUNM+JmgZNhVF2xQ@mail.gmail.com"
type="cite">
<div dir="ltr">Thanks Micha, but unfortunately this does not help
in my case.
<div><br>
</div>
<div>Árni</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature">
<div><br>
</div>
<font color="#666666">Árni Geirsson<br>
<span style="font-size:x-small"><font color="#666666"><b>Alta
ehf</b> // +354 582 5000 // +354 897 9549</font></span></font>
<div><font color="#666666"><span style="font-size:x-small"><a
moz-do-not-send="true" href="http://www.alta.is"
target="_blank"><a class="moz-txt-link-abbreviated" href="http://www.alta.is">www.alta.is</a></a> // </span><span
style="font-size:x-small"><a moz-do-not-send="true"
href="http://twitter.com/alta_ehf" target="_blank">Alta
á Twitter</a> // <a moz-do-not-send="true"
href="http://www.facebook.com/pages/Alta/161795813838691?v=wall"
target="_blank">Alta á Facebook</a></span></font><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Wed, Apr 27, 2016 at 12:32 PM, Micha
Silver <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:micha@arava.co.il" target="_blank">micha@arava.co.il</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="direction:ltr" text="#000000" bgcolor="#FFFFFF">
<div>
<div style="color:blue"> As for you point a) I think
that this thread on the Spatialite-users maillist
might be relevant:<br>
<a moz-do-not-send="true"
href="https://groups.google.com/forum/#%21topic/spatialite-users/uGDZr1TCTn8"
target="_blank">https://groups.google.com/forum/#!topic/spatialite-users/uGDZr1TCTn8</a><br>
<br>
The solution is to run the SQL function SELECT
UpdateLayerStatistics(); after adding columns. I
believe this has been incorporated into late versions
of QGIS.<br>
<br>
</div>
</div>
<br>
<br>
<br>
<div>On 04/27/2016 03:02 PM, Árni Geirsson wrote:<br>
</div>
<div>------ Original Message ------ Subject: [Qgis-user]
Problems with Spatialite Date: Wed, 27 Apr 2016 12:02:42
+0000 To: Qgis-user From: Árni Geirsson</div>
<blockquote type="cite">
<div>
<div class="h5">
<div dir="ltr">Dear QGIS users
<div>When developing spatial data in QGIS, i.e.
building data sets by adding features and
occasionally adding attributes, it appears to me
that there are three basic storage options
available.</div>
<div>1) The ubiquitous but fossilized Shapefile
format</div>
<div>2) PostgreSQL/PostGIS</div>
<div>3) Spatialite</div>
<div>I use all three and the first two work well
but there is certain pain in using Spatialite
that I would like to bring up in this forum to
see if there are other ways that I have missed.
I would like to be able to use Spatialite to
keep multiple datasets in one database file for
clean and simple storage and backups, plus the
database functionality. This pain with
Spatialite for me is however the following:</div>
<div>a) Adding columns seems to be problematic,
new columns do not appear when the layer is
added to QGIS. This seems to be an old problem
but I have not seen a solution.</div>
<div>b) Fetching data from a Spatialite database
stored on my NAS box is much slower than when it
is stored on the local computer. In a workgroup,
shared storage such as a NAS box is a necessity.</div>
<div>Now my question is: Are there solutions to
this or are there formats other than these three
that people are using for data set development
in QGIS, that I have missed? </div>
<div><br>
</div>
<div>
<div>
<div>Arni Geirsson</div>
</div>
</div>
</div>
<br>
</div>
</div>
This mail was received via Mail-SeCure System.<br>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
<span class="HOEnZb"><font color="#888888"> </font></span></blockquote>
<span class="HOEnZb"><font color="#888888">
<div>
<div dir="LTR"> Micha Silver<br>
Arava Drainage Authority<br>
+972-523-665918 </div>
</div>
</font></span></div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Matthias Kuhn
OPENGIS.ch - <a class="moz-txt-link-freetext" href="https://www.opengis.ch">https://www.opengis.ch</a>
Spatial • (Q)GIS • PostGIS • Open Source</pre>
</body>
</html>