[Qgis-user] Question on Spatialite

[Andrew Harfoot]

Another option would be to do this in the DB Manager - ie use the SQLite 
engine directly, but you would have to recouch your Field Calculator 
expression as SQL.

Andy

On 01/03/2017 22:33, Randal Hale wrote:
> Attribute! Used Field Calculator to split an attribute to get the 
> zipcode into a standalone column. I then hit save and watched the fun.
>
> And yes that seems to be it. Good, I'm not crazy (on this issue).
>
> Randy
>
>
> On 03/01/2017 05:23 PM, Nyall Dawson wrote:
>> On 2 March 2017 at 08:08, Randal Hale 
>> <rjhale at northrivergeographic.com> wrote:
>>> I'm using 2.18.4
>>>
>>> I'm working with Address point data. My typical process is to import 
>>> the
>>> data into PostGIS/Postgresql and work with it. I decided to work with
>>> spatialite and do some data cleanup.
>>>
>>> I have 222519 points. I made a change to all of them and hit save.
>> What change did you make? Attribute or geometry? How was this change 
>> made?
>>
>> It possibly relates to this ongoing work: 
>> https://github.com/qgis/QGIS/pull/4175
>>
>>
>> Nyall
>>
>>> So for
>>> the next 20 minutes I watched a very small journal file appear and 
>>> disappear
>>> and QGIS just locked up until it was done. QGIS returned to normal 
>>> and I'm
>>> working along again.
>>>
>>> So my question is - Can I avoid this happening easily or is this just a
>>> "it's what happens with spatialite" problem? Am I missing a setting
>>> somewhere?
>>>
>>> Randy
>>>
>>>
>>> -- 
>>> ------------------------------------------------
>>> Randal Hale
>>> North River Geographic Systems, Inc
>>> http://www.northrivergeographic.com
>>> 423.653.3611 rjhale at northrivergeographic.com
>>> twitter:rjhale     http://about.me/rjhale
>>> http://www.northrivergeographic.com/introduction-to-quantum-gis
>>> https://www.facebook.com/NRGSInc
>>>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>


-- 
Andy Harfoot

GeoData Institute
University of Southampton
Southampton
SO17 1BJ

Tel:  +44 (0)23 8059 2719

www.geodata.soton.ac.uk