<html><head></head><body><div class="ydp5dc02734yahoo-style-wrap" style="font-family: verdana, helvetica, sans-serif; font-size: 13px;"><div><div dir="ltr" data-setdir="false"><div dir="ltr" data-setdir="false"><div dir="ltr" data-setdir="false">Local groups sometimes ask how they could access Changesets metadata to monitor edits. ToeBee ChangesetMD is available since 2012 to replicate OSM changeset metadata in a PostgreSQL database. While the actual script can respond to experienced developpers needs working on linux, the learning curve is a quite steep for many.<br></div><div dir="ltr" data-setdir="false"><a href="https://github.com/ToeBee/ChangesetMD" rel="nofollow" target="_blank">https://github.com/ToeBee/ChangesetMD</a></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><span>Note that their are at the beginning of 2021, nearly 100 million records. The complete Replication file is 4Gb at the beginning of 2021.</span><br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">mvexel has made a proposition to upgrade it to python3 since python2 is not supported since 2021.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I myself propose some enhancements based on Python 3 that could respond to other needs than Complete operational database.Various local groups could for example extract metadata for only a week that correspond to a local event to monitor.<br></div><br><div>This is a prototype that i Invite you to look, test it if you already have a PosgreSQL Db (9.5+) installed. You can easily create a new Database and schema from the Windows Powershell script provided. A test file is provided for the first Insert to the Db. It is also possible to replicate from the Planet Replication site. <br></div><div><br></div><div dir="ltr" data-setdir="false">I have developped and tested this on my laptop. The tests available work with sample data and are completed in minutes.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">For many of us, it is a good time to test early 2021. Have fun!<br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">If you create a test Repository and try to replicate from the Planet Replication site, you dont need to let these scripts run for hours. You can at any time interrupt the process and records will have been kept up to the last Bulk rows inserted. You can even restart the replication since the sequence of the last file replicated is kept in the database.<br></div><div><br></div><div dir="ltr" data-setdir="false"> See documentation at https://github.com/pierzen/ChangesetMD/tree/dopartial-log</div><div dir="ltr" data-setdir="false">The test subdirectory contains Test files (Windows OS Powershell scripts) that make it easy to test. Linuxians should be able to adapt these scripts easily.<br></div></div></div><div class="ydp5dc02734signature"><span style="font-style:italic;color:rgb(0, 0, 191);font-weight:bold;"> <br><font style="background-color: inherit;" face="garamond, new york, times, serif">Pierre </font><br></span></div></div></div></body></html>