[Qgis-user] How to Prevent GeoPackage file from updating modified date when viewed in a Qgis project when it is not being edited

[baswein]

I too am struggling with how to use geopackages with a team. And am wondering
if anyone has figured out how to keep them from being marked as changed when
opened for viewing in QGIS.  This is fine with small geopackages but with
large ones it uses up a lot of bandwidth.
QSettings().setValue("/qgis/walForSqlite3", False) makes it not enter WAL
mode but it still is marked as changed. Changing the environment variable
OGR_SQLITE_JOURNAL = DELETE also turns off WAL mode but still marks the file
as changes. We use google file stream and it is not possible to mark the
file as read only in google file steam so that is not an option. 
I guess my question is are geopackages just incompatible with any sort of
syncing service- google drive, drive file stream, dropbox, one drive, etc? 
If that is the case I think that could be a severe limiting factor for the
format as these file syncing services are ubiquitous at this point and are
likely to increase in the increasingly work from home environment that we
are facing.  
In my naivety I image a system that does not mark the file as changed when
loaded but when any of the layers are toggled for editing it creates a lock
file that prevents other users from editing the file as MS Word does. After
the layer is saved and editing is toggled off the lock file disappears (is
this what the WAL file si doing?). I know there could still be issues with
network latency but if google decided that there is a conflict and it
creates a duplicate file.  
Please don't make me go back to shpfls! :)
-Bas  



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html