<div dir="ltr"><div dir="ltr">Hi all,<div><br></div><div>Interesting discussion!</div><div><br></div><div>Standard does not care (and should not care to great extent) about use cases. Creating revisions and incremental changelogs is a common use case (unless you work with my-spatial_data_v010_final_draft_final_002_really-final_005.gpkg :) ), you have those common use cases.</div><div><br></div><div>Providing a tool similar to geodiff or Detect dataset changes algorithms can help users to overcome the limitation of standards...</div><div><br></div><div>Regards</div><div>Saber</div><div><br></div><div><br></div><div> </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, 8 May 2020 at 11:48, Matthias Kuhn <<a href="mailto:matthias@opengis.ch">matthias@opengis.ch</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
  
    
  
  <div>
    <p>Hi Tim<br>
    </p>
    <div>On 5/8/20 12:25 PM, Tim Sutton wrote:<br>
    </div>
    <blockquote type="cite">
      
      Hi<br>
      <div><br>
        <blockquote type="cite">
          <div>On 8 May 2020, at 10:34, Werner Macho <<a href="mailto:werner.macho@gmail.com" target="_blank">werner.macho@gmail.com</a>>
            wrote:</div>
          <br>
          <div>
            <div dir="ltr">Hi Matthias,
              <div><br>
              </div>
              <div>May I add another pain here?</div>
              <div><br>
              </div>
              <div>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>On very large gpkg files this is also not
                really nice.</div>
              <div>(Maybe I am just using gpkg wrong, but at
                least this happens on my installation)</div>
            </div>
          </div>
        </blockquote>
        <div><br>
        </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">
      <div>
        <div><br>
        </div>
        <div>[1]<a href="https://github.com/lutraconsulting/geodiff" target="_blank">https://github.com/lutraconsulting/geodiff</a></div>
        <div><br>
        </div>
      </div>
      Regards
      <div><br>
      </div>
      <div>Tim<br>
        <div>
          <div style="font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;color:rgb(0,0,0);font-size:12px;line-height:normal;text-align:center"><span>—</span></div>
          <div style="font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;color:rgb(0,0,0);font-size:12px;line-height:normal;text-align:center">
            <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br>
            </div>
            <br style="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;text-decoration:none">
            <span style="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;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 id="gmail-m_-5984182782924228390B818BE14-3DBF-4AFB-94C0-06DE1290ED8A" src="cid:171f464d6862451cdf21"></span>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br>
            <br>
            <br>
            <br>
            <br>
            <br>
          </div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br>
          </div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>Tim Sutton</b></div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br>
          </div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>Co-founder:</b><span> </span>Kartoza</div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>Ex Project chair:</b><span style="font-weight:normal"><span> </span><a href="http://QGIS.org" target="_blank">QGIS.org</a></span></div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br>
          </div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">Visit <a href="http://kartoza.com/" target="_blank"><span>http://kartoza.com</span></a> to find out about
            open source:</div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br>
          </div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">Desktop
            GIS programming services</div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">Geospatial
            web development</div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">GIS
            Training</div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal">Consulting
            Services</div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal;min-height:14px"><br>
          </div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>Skype</b>: timlinux </div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><b>IRC:</b><span> </span>timlinux
            on #qgis at <a href="http://freenode.net" target="_blank">freenode.net</a></div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><br>
          </div>
          <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;margin:0px;line-height:normal"><span style="color:rgb(102,106,115);font-family:"Proxima Nova",sans-serif;font-size:14px;text-align:left;background-color:rgb(255,255,255)">I'd love
              to connect. </span><a href="https://calendly.com/timlinux/30min" target="_blank">Here's my calendar link</a><span style="color:rgb(102,106,115);font-family:"Proxima Nova",sans-serif;font-size:14px;text-align:left;background-color:rgb(255,255,255)"> to make
              finding time easy.</span></div>
        </div>
        <br>
      </div>
    </blockquote>
  </div>

_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Saber Razmjooei<br></div><div><a href="http://www.lutraconsulting.co.uk" target="_blank">www.lutraconsulting.co.uk</a><br><br></div></div></div></div></div></div></div></div></div></div></div>