<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 href="http://www.alta.is" target="_blank">www.alta.is</a> // </span><span style="font-size:x-small"><a href="http://twitter.com/alta_ehf" target="_blank">Alta á Twitter</a> // <a 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 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 href="https://groups.google.com/forum/#!topic/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 href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a 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>