<html style="direction: ltr;">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
smarttemplateinserted="true" text="#000000" bgcolor="#FFFFFF">
<div id="smartTemplate4-template">
<div id="my_message" style="color:blue; ">
As for you point a) I think that this thread on the
Spatialite-users maillist might be relevant:<br>
<a class="moz-txt-link-freetext" href="https://groups.google.com/forum/#!topic/spatialite-users/uGDZr1TCTn8">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 class="moz-cite-prefix">On 04/27/2016 03:02 PM, Árni Geirsson
wrote:<br>
</div>
<div id="smartTemplate4-quoteHeader">------ 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
cite="mid:CALtMHXiwRk0CKziMcAgP88TuG-+xvkooK-XTTe=k7ETu05+_7w@mail.gmail.com"
type="cite">
<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 class="gmail_signature">Arni Geirsson</div>
</div>
</div>
</div>
<br>
This mail was received via Mail-SeCure System.<br>
<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>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<div class="moz-signature">
<div dir="LTR">
Micha Silver<br>
Arava Drainage Authority<br>
+972-523-665918
</div>
</div>
</body>
</html>