(comments)
原始链接: https://news.ycombinator.com/item?id=44017956
Hacker News users are discussing RepoRoulette, a new tool that randomly samples GitHub repositories. One user, zX41ZdbW, shared a similar project they created five years ago, "GitHub Roulette," implemented with a single, continuously updated SQL query using ClickHouse. They provided a link to both the project and the query. The original poster, deontology, appreciated the similar name of zX41ZdbW's project. Another user, raphinou, thanked zX41ZdbW for sharing, expressing interest in integrating this functionality into their project, Freshstuff.net, which lists new releases on GitHub, as a discovery method.
It is done with a single SQL query, and the data is continuously updated: https://play.clickhouse.com/play?user=play#U0VMRUNUIHJlcG9fb...
reply