[QGIS-Developer] gpkg syncing issue

[Daniele Viganò]

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>
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
> QGIS.ORG Chair:
> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
> _______________________________________________
> 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



-- 
*Daniele Viganò*
http://daniele.vigano.me
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190313/ada6fb6a/attachment.html>