<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Resolution attempt in <a class="moz-txt-link-freetext" href="https://github.com/qgis/QGIS/pull/47098">https://github.com/qgis/QGIS/pull/47098</a></p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 11/01/2022 à 15:10,
<a class="moz-txt-link-abbreviated" href="mailto:pergler@gmail.com">pergler@gmail.com</a> a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:065501d806f5$0dfba760$29f2f620$@gmail.com">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<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. </p>
<p class="MsoNormal"> </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. </p>
<p class="MsoNormal"> </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.</p>
<p class="MsoNormal"> </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?</p>
<p class="MsoNormal">Thanks!</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span>---</span></p>
<p class="MsoNormal"><span>Martin Pergler</span></p>
<p class="MsoNormal"> </p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>