Thanks Micha, but unfortunately this does not help in my case. Árni
Árni Geirsson *Alta ehf* // +354 582 5000 // +354 897 9549 www.alta.is // Alta á Twitter <http://twitter.com/alta_ehf> // Alta á Facebook <http://www.facebook.com/pages/Alta/161795813838691?v=wall> On Wed, Apr 27, 2016 at 12:32 PM, Micha Silver <[email protected]> wrote: > As for you point a) I think that this thread on the Spatialite-users > maillist might be relevant: > https://groups.google.com/forum/#!topic/spatialite-users/uGDZr1TCTn8 > > The solution is to run the SQL function SELECT UpdateLayerStatistics(); > after adding columns. I believe this has been incorporated into late > versions of QGIS. > > > > > On 04/27/2016 03:02 PM, Árni Geirsson wrote: > ------ Original Message ------ Subject: [Qgis-user] Problems with > Spatialite Date: Wed, 27 Apr 2016 12:02:42 +0000 To: Qgis-user From: Árni > Geirsson > > Dear QGIS users > 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. > 1) The ubiquitous but fossilized Shapefile format > 2) PostgreSQL/PostGIS > 3) Spatialite > 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: > 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. > 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. > 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? > > Arni Geirsson > > This mail was received via Mail-SeCure System. > > > _______________________________________________ > Qgis-user mailing [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > This mail was received via Mail-SeCure System. > > Micha Silver > Arava Drainage Authority > +972-523-665918 >
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
