<p><a class="user-mention" data-hovercard-type="user" data-hovercard-url="/hovercards?user_id=766031" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/Zverik">@Zverik</a> has brought up this topic again in <a href="http://shtosm.ru/all/zhelaem-togo-chto-imeem/" rel="nofollow">http://shtosm.ru/all/zhelaem-togo-chto-imeem/</a> and <a href="https://2019.stateofthemap.org/sessions/V7NUWP/" rel="nofollow">https://2019.stateofthemap.org/sessions/V7NUWP/</a></p>
<p>This could be done by a single SQL statement (see <a href="https://gist.github.com/mmd-osm/fff7f5620def9affd5477da6aeb419b9">https://gist.github.com/mmd-osm/fff7f5620def9affd5477da6aeb419b9</a> for how this could look like for ways). I don't know how expensive this is in production, and if we should restrict it to a range of version numbers rather than evaluating the full history.</p>
<p>The example query returns a flat list of node id/version numbers, which would be served back to the client along with the respective way versions (which is a separate SQL statement). This way, the amount of data to be transferred would be kept to an absolute minimum. It would be the responsibility of the client to reassemble the full history based on those node and way versions, which shouldn't really be an issue.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/130?email_source=notifications&email_token=AAK2OLK5NVKBJ4GUZGA7GRDQMDRBBA5CNFSM4ABSL2EKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD732ILY#issuecomment-536323119">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLKKUSLI6YP22HKHBU3QMDRBBANCNFSM4ABSL2EA">mute the thread</a>.<img src="https://github.com/notifications/beacon/AAK2OLIHEARAE7QU4OXWIZLQMDRBBA5CNFSM4ABSL2EKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD732ILY.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/130?email_source=notifications\u0026email_token=AAK2OLK5NVKBJ4GUZGA7GRDQMDRBBA5CNFSM4ABSL2EKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD732ILY#issuecomment-536323119",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/130?email_source=notifications\u0026email_token=AAK2OLK5NVKBJ4GUZGA7GRDQMDRBBA5CNFSM4ABSL2EKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD732ILY#issuecomment-536323119",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>