News for hackers. Stuff that matters.
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