News for hackers. Stuff that matters.
Re:Show HN: Most active bots commenting on GitHub in the pas... by seiflotfy on Wednesday October 06, 2021 @12:52PM (#28775340)
You can run the same query with a query builder here https://play.axiom.co/axiom-play-qf1k/datasets/github-issues...

I changed it to 90 days :D

Re:Show HN: Most active bots commenting on GitHub in the pas... by ucirello on Wednesday October 06, 2021 @12:57PM (#28775405)
that reminds of that presentation about Google's monorepo, in which a graph makes the distinction of the commits made by humans versus done by bots. The bots there were really active.
Re:Show HN: Most active bots commenting on GitHub in the pas... by tdeck on Thursday October 07, 2021 @08:00PM (#28793754)
Google makes use of its main version control system in a really unusual way. Because the system can handle both very large volumes of commits and large binary files, you get some systems that make use of it in ways you wouldn't see with Git. Some examples:

- Build pipelines that build an artifact based on a build number in a file in version control, then check in a commit that increments that build number for the next job, and finally check in the built artifact in another commit somewhere else.

- An oncall scheduler that uses a big config file to keep track of everything. At the top is a description of the rotation and people involved. At the bottom is a list of names in order for the next, say, 10 cycles. At the beginning of each OnCall cycle, a job deletes the name at the top of the second list, moving the next name to the top. That's who is OnCall. Another job occasionally "refills" the bottom list by generating new rotation cycles from the names at the top and appending them.

Re:Show HN: Most active bots commenting on GitHub in the pas... by abahlo on Wednesday October 06, 2021 @01:59PM (#28776161)
Wow, dependabot opened 2.7 Million PRs in the last 30 days https://play.axiom.co/axiom-play-qf1k/explorer?qid=blX8pIiTb...
Re:Show HN: Most active bots commenting on GitHub in the pas... by elesbao on Wednesday October 06, 2021 @12:45PM (#28775239)
how big is the dataset ? I am wondering that if this is a month worth of bots comment that's a lot of data and the interface feels snappy.
Re:Show HN: Most active bots commenting on GitHub in the pas... by seiflotfy on Wednesday October 06, 2021 @01:07PM (#28775526)
the query is faster is written is follows

``` ['github-issue-comment-event'] | where actor contains "-bot" or actor contains "[bot]" | summarize count() by bin_auto(_time), actor | take 20 ```

Re:Show HN: Most active bots commenting on GitHub in the pas... by seiflotfy on Wednesday October 06, 2021 @12:52PM (#28775331)
90 days only we will backfill at some point but we need to test a bit more
Re:Show HN: Most active bots commenting on GitHub in the pas... by r0dms on Thursday October 07, 2021 @04:05PM (#28791400)
Very cool, thanks for sharing!