[QGIS-Developer] gpkg syncing issue
Even Rouault
even.rouault at spatialys.com
Wed Mar 13 09:53:06 PDT 2019
On mercredi 13 mars 2019 17:44:11 CET Paolo Cavallini 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?
Yes this is a known inconvenience (pretty sure there might be bugs open on
this) due to opening GPKG files in write-ahead mode, so as to avoid issues in
case of concurrent editing (probably helps also in situations of single
editing where one thread does writing, and others are reading)
You can set the OGR_SQLITE_JOURNAL = DELETE environment variable, or the qgis/
walForSqlite3 = false setting to avoid that (but run in the possible above
mentionned issues)
Even
--
Spatialys - Geospatial professional services
http://www.spatialys.com
More information about the QGIS-Developer
mailing list