<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:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
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:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>I’ve packaged a number of read-only layers (e.g. contours, watercourses) for my area of interest into one gpkg. However, QGIS writes changes to this gpkg every time it is opened, even if the layers themselves are never edited. I think this is related to SQLite wal journaling. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>It’s an annoyance since it’s a large file that gets unnecessarily reuploaded in every incremental backup, and when I’m in the field, that’s sometimes over a bad 3G cell connection. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve tried making the gpkg read-only, which hasn’t crashed anything in brief testing and generates no warnings. However, it feels risky, and clearly QGIS or OGR aren’t fully happy, since the temporary shm and wal files don’t get deleted on exit. So I’m hesitant to continue doing this for fear of a crash when I’m actually doing something useful.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Is there a better way to tell QGIS to not write to a gpkg in which all layers are only being accessed read-only?<o:p></o:p></p><p class=MsoNormal>Thanks!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:9.0pt;mso-fareast-language:EN-CA'>---<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;mso-fareast-language:EN-CA'>Martin Pergler<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>