https://issues.qgis.org/https://issues.qgis.org/favicon.ico2013-10-18T11:54:01ZQGIS Issue TrackingQGIS Application - Bug report #8908: spatialite database updated only from opening qgis projecthttps://issues.qgis.org/issues/8908?journal_id=457922013-10-18T11:54:01ZJosef Källgården
<ul><li><strong>File</strong> <a href="/attachments/download/6385/testdb.sqlite.zip">testdb.sqlite.zip</a> added</li></ul><p>Attached sample database. The database will be updated as soon as the view4 is added as a layer to a qgis project.<br />I <em>think</em> it is related to the null values in views_geometry_columns_statistics.</p> QGIS Application - Bug report #8908: spatialite database updated only from opening qgis projecthttps://issues.qgis.org/issues/8908?journal_id=458342013-10-20T11:48:40Zaperi2007 -aperi2007@gmail.com
<ul></ul><p>I guess to better understand the question and why it do this is preferrable to link the discussion on spatialite ML about it and the Furieri response.</p>
<p><a class="external" href="https://groups.google.com/forum/#!topic/spatialite-users/6PW_iICSEG8">https://groups.google.com/forum/#!topic/spatialite-users/6PW_iICSEG8</a></p>
<p>A.</p> QGIS Application - Bug report #8908: spatialite database updated only from opening qgis projecthttps://issues.qgis.org/issues/8908?journal_id=462732013-11-11T12:03:13ZJosef Källgården
<ul></ul><p>As Furieri explains in the discussion on spatalite ML it is the optimistic approach (GAIA_VECTORS_LIST_OPTIMISTIC) of the qgs data provider that makes a spatialite db <em>not</em> being updated when a spatialite view is added to qgis. But as explained in the description above, whenever a spatialite view is empty, the db gets updated. I think this is an inconsistent behaviour.</p>
<p>Even though I would prefer that the db were not updated unless actual changes were made (easier when synching after offline use), I would very much prefer the behaviour to be consistent no matter if the view is empty or not. I can think of a few alternatives, but there are probably others:<br />a. stay with optimistic approach and fix a consistent behaviour by introducing some clever code in data provider to never update db unless time stamps say underlaying tables are updated<br />b. change to pessimistic approach <br />c. do nothing and stay with this inconsistency (I hope not)</p> QGIS Application - Bug report #8908: spatialite database updated only from opening qgis projecthttps://issues.qgis.org/issues/8908?journal_id=478052014-01-28T03:09:53ZMatthias Kuhn
<ul><li><strong>Priority</strong> changed from <i>Severe/Regression</i> to <i>Normal</i></li></ul> QGIS Application - Bug report #8908: spatialite database updated only from opening qgis projecthttps://issues.qgis.org/issues/8908?journal_id=785712017-04-30T23:09:18ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Regression?</strong> set to <i>No</i></li><li><strong>Easy fix?</strong> set to <i>No</i></li></ul> QGIS Application - Bug report #8908: spatialite database updated only from opening qgis projecthttps://issues.qgis.org/issues/8908?journal_id=880822018-03-01T11:28:56ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Please test with a recent QGIS release (2.18 or 3), if the issue/request is still valid change the affected version accordingly, if is fixed/implemented then close the ticket. Thanks!</p> QGIS Application - Bug report #8908: spatialite database updated only from opening qgis projecthttps://issues.qgis.org/issues/8908?journal_id=889542018-03-26T18:28:54ZJosef Källgården
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Open</i></li></ul><p>Giovanni Manghi wrote:</p>
<blockquote>
<p>Please test with a recent QGIS release (2.18 or 3), if the issue/request is still valid change the affected version accordingly, if is fixed/implemented then close the ticket. Thanks!</p>
</blockquote>
<p>Confirmed this issue still exists for qgis version 2.18.16 (For some reason I can not change affected version in the original bug report above.)</p> QGIS Application - Bug report #8908: spatialite database updated only from opening qgis projecthttps://issues.qgis.org/issues/8908?journal_id=1016082019-03-09T14:07:49ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>end of life</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p><strong>End of life notice: QGIS 2.18 LTR</strong></p>
<p><strong>Source:</strong><br /><a class="external" href="http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/">http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/</a></p>
<p>QGIS 3.4 has recently become our new Long Term Release (LTR) version. This is a major step in our history – a long term release version based on the massive updates, library upgrades and improvements that we carried out in the course of the 2.x to 3x upgrade cycle.</p>
<p>We strongly encourage all users who are currently using QGIS 2.18 LTR as their preferred QGIS release to migrate to QGIS 3.4. This new LTR version will receive regular bugfixes for at least one year. It also includes hundreds of new functions, usability improvements, bugfixes, and other goodies. See the relevant changelogs for a good sampling of all the new features that have gone into version 3.4</p>
<p>Most plugins have been either migrated or incorporated into the core QGIS code base.</p>
<p>We strongly discourage the continued use of QGIS 2.18 LTR as it is now officially unsupported, which means we’ll not provide any bug fix releases for it.</p>
<p>You should also note that we intend to close all bug tickets referring to the now obsolete LTR version. Original reporters will receive a notification of the ticket closure and are encouraged to check whether the issue persists in the new LTR, <strong>in which case they should reopen the ticket</strong>.</p>
<p>If you would like to better understand the QGIS release roadmap, check out our roadmap page! It outlines the schedule for upcoming releases and will help you plan your deployment of QGIS into an operational environment.</p>
<p>The development of QGIS 3.4 LTR has been made possible by the work of hundreds of volunteers, by the investments of companies, professionals, and administrations, and by continuous donations and financial support from many of you. We sincerely thank you all and encourage you to collaborate and support the project even more, for the long term improvement and sustainability of the QGIS project.</p>