[QGIS-Developer] gpkg syncing issue

[Paolo Cavallini]

nothing to do with multiwrite, but with backupping and syncing.
I have a dir of shp that I sync with a couple of servers, and I
incrementally backup the dir. All fine and efficient. With gpkg the
packages will be saved over and over again even if unchanged.
this is a very serious limitation in professional contests, IMHO.
Cheers.

On 13/03/19 18:01, Daniele Viganò wrote:
> That comes from the fact that a GeoPackage is essentially an SQLite DB,
> and SQLite 3 uses WAL by default [1]
> 
> See Even reply for workarounds. Anyway SQLite is not meant to be used
> with multiple writing processes.
> 
> Cheers,
> Daniele
> 
> [1] https://www.sqlite.org/wal.html
> 
> On Wed, Mar 13, 2019 at 5:44 PM Paolo Cavallini <cavallini at faunalia.it
> <mailto:cavallini at faunalia.it>> wrote:
> 
>     Hi all,
>     when a geopackage is opened in QGIS, even if no change is made, the file
>     is marked as changed. This can cause nightmares when syncing data,
>     because if two users open a gpkg without editing, it is hard to decide
>     what to do. Same for backups.
>     Is there a way to avoid this?
>     Thanks.
>     -- 
>     Paolo Cavallini - www.faunalia.eu <http://www.faunalia.eu>
>     QGIS.ORG <http://QGIS.ORG> Chair:
>     http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>     _______________________________________________
>     QGIS-Developer mailing list
>     QGIS-Developer at lists.osgeo.org <mailto:QGIS-Developer at lists.osgeo.org>
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> 
> 
> -- 
> *Daniele Viganò*
> http://daniele.vigano.me
> 
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/