<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Tim<br>
</p>
<div class="moz-cite-prefix">On 5/8/20 12:25 PM, Tim Sutton wrote:<br>
</div>
<blockquote type="cite"
cite="mid:27D9C863-0F49-46D5-82BE-588CC47DFB2E@kartoza.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Hi<br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On 8 May 2020, at 10:34, Werner Macho <<a
href="mailto:werner.macho@gmail.com" class=""
moz-do-not-send="true">werner.macho@gmail.com</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">Hi Matthias,
<div class=""><br class="">
</div>
<div class="">May I add another pain here?</div>
<div class=""><br class="">
</div>
<div class="">Storing gpkg in the cloud means syncing even
after the file was only opened in QGIS and nothing
has changed inside - it was only opened to view
something.</div>
<div class="">On very large gpkg files this is also not
really nice.</div>
<div class="">(Maybe I am just using gpkg wrong, but at
least this happens on my installation)</div>
</div>
</div>
</blockquote>
<div><br class="">
</div>
<div>In some cases you may be able to work around this by using
geodiff from our fine friends over at Lutra. It will let you
extract just the changes (if you have the original and the
changed copy locally), then upload them to the server.</div>
</div>
</blockquote>
<p>Thanks for mentioning that. This might indeed be good for very
controlled environments but adds quite a bit of additional
requirements on logic and services. In those cases you are often
better off setting up a postgres database directly.<br>
</p>
<p>In this thread, let's focus on "how to get things to work
properly for our standard geo container file."</p>
<p>Matthias</p>
<blockquote type="cite"
cite="mid:27D9C863-0F49-46D5-82BE-588CC47DFB2E@kartoza.com">
<div>
<div><br class="">
</div>
<div>[1]<a href="https://github.com/lutraconsulting/geodiff"
class="" moz-do-not-send="true">https://github.com/lutraconsulting/geodiff</a></div>
<div><br class="">
</div>
</div>
Regards
<div class=""><br class="">
</div>
<div class="">Tim<br class="">
<div class="">
<div style="font-family: Helvetica; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; text-decoration: none;
color: rgb(0, 0, 0); font-size: 12px;
font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; line-height: normal; text-align: center;" class=""><span>—</span></div>
<div style="font-family: Helvetica; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; text-decoration: none;
color: rgb(0, 0, 0); font-size: 12px;
font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; line-height: normal; text-align: center;" class="">
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style:
normal; font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; text-align: center; text-indent:
0px; text-transform: none; white-space: normal;
word-spacing: 0px; -webkit-text-stroke-width: initial;
text-decoration: none; font-variant-ligatures: normal;
font-variant-position: normal; font-variant-numeric:
normal; font-variant-alternates: normal;
font-variant-east-asian: normal; margin: 0px; line-height:
normal; -webkit-text-stroke-color: rgb(0, 0, 0);
min-height: 14px;" class=""><br class="">
</div>
<br class="Apple-interchange-newline" style="caret-color:
rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica;
font-size: 12px; font-style: normal; font-variant-caps:
normal; font-weight: normal; letter-spacing: normal;
text-align: center; text-indent: 0px; text-transform:
none; white-space: normal; word-spacing: 0px;
-webkit-text-stroke-width: 0px; text-decoration: none;">
<span style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style:
normal; font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; text-align: center; text-indent:
0px; text-transform: none; white-space: normal;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
text-decoration: none;"><span><span><span><span><span><span><span><span><span><span><span></span></span></span></span></span></span></span></span></span></span></span></span></div>
<span><img apple-inline="yes"
id="B818BE14-3DBF-4AFB-94C0-06DE1290ED8A"
src="cid:part3.98FC0DBB.B69E5157@opengis.ch" class=""></span>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;"
class=""><br class="Apple-interchange-newline">
<br class="Apple-interchange-newline">
<br class="Apple-interchange-newline">
<br class="Apple-interchange-newline">
<br class="Apple-interchange-newline">
<br class="">
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;"
class=""><br class="">
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b
class="">Tim Sutton</b></div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;"
class=""><br class="">
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b
class="">Co-founder:</b><span
class="Apple-converted-space"> </span>Kartoza</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b
class="">Ex Project chair:</b><span style="font-weight:
normal;" class=""><span class="Apple-converted-space"> </span><a
href="http://QGIS.org" class="" moz-do-not-send="true">QGIS.org</a></span></div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;"
class=""><br class="">
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class="">Visit <a
href="http://kartoza.com/" class="" moz-do-not-send="true"><span
style="-webkit-text-stroke-color: rgb(71, 135, 255);"
class="">http://kartoza.com</span></a> to find out about
open source:</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;"
class=""><br class="">
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class="">Desktop
GIS programming services</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class="">Geospatial
web development</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class="">GIS
Training</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class="">Consulting
Services</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0); min-height: 14px;"
class=""><br class="">
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b
class="">Skype</b>: timlinux </div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class=""><b
class="">IRC:</b><span class="Apple-converted-space"> </span>timlinux
on #qgis at <a href="http://freenode.net" class=""
moz-do-not-send="true">freenode.net</a></div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class=""><br
class="">
</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0);
font-family: Helvetica; font-size: 12px; font-style: normal;
font-variant-caps: normal; font-weight: normal;
letter-spacing: normal; orphans: auto; text-align: center;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-size-adjust:
auto; -webkit-text-stroke-width: initial; text-decoration:
none; font-variant-ligatures: normal; font-variant-position:
normal; font-variant-numeric: normal;
font-variant-alternates: normal; font-variant-east-asian:
normal; margin: 0px; line-height: normal;
-webkit-text-stroke-color: rgb(0, 0, 0);" class=""><span
style="caret-color: rgb(102, 106, 115); color: rgb(102,
106, 115); font-family: "Proxima Nova",
sans-serif; font-size: 14px; text-align: left;
background-color: rgb(255, 255, 255);" class="">I'd love
to connect. </span><a
href="https://calendly.com/timlinux/30min" class=""
moz-do-not-send="true">Here's my calendar link</a><span
style="caret-color: rgb(102, 106, 115); color: rgb(102,
106, 115); font-family: "Proxima Nova",
sans-serif; font-size: 14px; text-align: left;
background-color: rgb(255, 255, 255);" class=""> to make
finding time easy.</span></div>
</div>
<br class="">
</div>
</blockquote>
</body>
</html>