Hi Árni, There is an issue report open with some background information regarding this topic: http://hub.qgis.org/issues/8923
Regards, Matthias On 04/27/2016 02:47 PM, Árni Geirsson wrote: > 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 <http://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] > <mailto:[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 > <https://groups.google.com/forum/#%21topic/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 list >> [email protected] <mailto:[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 -- Matthias Kuhn OPENGIS.ch - https://www.opengis.ch Spatial • (Q)GIS • PostGIS • Open Source
_______________________________________________ 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
