FYI, I did exactly this five years ago: <a href="https://ghe.clickhouse.tech/#github-roulette" rel="nofollow">https://ghe.clickhouse.tech/#github-roulette</a><p>It is done with a single SQL query, and the data is continuously updated: <a href="https://play.clickhouse.com/play?user=play#U0VMRUNUIHJlcG9fbmFtZSBGUk9NIGdpdGh1Yl9ldmVudHMgV0hFUkUgZXZlbnRfdHlwZSA9ICdXYXRjaEV2ZW50JyBPUkRFUiBCWSByYW5kKCkgTElNSVQgNTA=" rel="nofollow">https://play.clickhouse.com/play?user=play#U0VMRUNUIHJlcG9fb...</a>
Thanks for sharing, this is something I also wanted to do but never took the time to implement.<p>I could use it in a project of mine listing new releases published on GitHub [1] as an additional way to discover repos.<p>1: <a href="https://freshstuff.net/" rel="nofollow">https://freshstuff.net/</a>