[Qgis-user] Problems with Spatialite

[Matthias Kuhn]

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 <micha at arava.co.il
> <mailto:micha at arava.co.il>> 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
>>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>>     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
> Qgis-user at lists.osgeo.org
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160427/ff4a7152/attachment.html>