<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-CA link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>I would really like to use and promote GeoPackage as the go to data format in my organization but I am having the following problem that I haven’t been able to solve.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When ever someone opens a Q template project that has a layer with a GeoPackage data source, the GeoPackage file (not its contents) will be altered and it will show that it has been updated in the Windows file manager. I have been told that this happens because the write ahead logging has been triggered (creation of *.wal and *.shm) files by simply viewing the contents of the GeoPackage in QGIS and/or in Intramaps Roam (works on top of QGIS for tablets). <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This is problematic because most users in our organization will then look at the windows modified date time stamp and conclude that the file’s contents have been modified. Additionally, all of the GIS layers are stored in Dropbox and subsequently Dropbox concludes that the file has been modified and it re-uploads a new copy of the GeoPackage. When it is a large GeoPackage > 1 GB in size this is quite problematic and causes a cascade of uploads and downloads.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Over the last few months I have tried to suppress this modification for the large GeoPackages in our system in the following ways: (1) make the layer read only in the QGIS project (no effect); (2) make the Dropbox folder read only for all users except the Dropbox administrator (this is effective for the large base layers); (3) change the properties of the file in windows to read only (effective for the Dropbox administrator); and (4) add a user variable to the windows system environment variables: OGR_SQLITE_JOURNAL = DELETE (effective for QGIS but not for Intramaps Roam)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Combining 2, 3, and 4 allows me to use GeoPackage for layers I can ensure are placed in the read-only Dropbox folders.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>It is likely that my organization will never need the simultaneous editing of datasets that is facilitated by Write-Ahead Logging, but I would really like to be able to replace shapefiles and File geodatabases with GeoPackages in all of our projects going forward.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Therefore, is there a simpler way to suppress the write ahead logging behaviour that causes the files to believe they have been updated for all GeoPackages created in QGIS or used in a QGIS project? <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Rob<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>