🪞 This repository, watching itself grow — day by day
June day
Events
Pushes
+3
9
5
2
…
10
3
3
…
11
3
3
…
12
9
7
…
Run this query →no server · no download · no account
caviri.github.io/rete
Run this query in the playground →19 rows · 33.7 s · 39.0 MB of 6.04 GB read over HTTP range · no server, no download — the query runs in your browser.
The query
PREFIX gh: <https://w3id.org/rete/gharchive#>
PREFIX prov: <http://www.w3.org/ns/prov#>
SELECT ?day (COUNT(*) AS ?events)
(SUM(IF(?type = gh:PushEvent, 1, 0)) AS ?pushes)
(SUM(IF(?type = gh:CreateEvent, 1, 0)) AS ?branchesCreated)
(SUM(IF(?type = gh:DeleteEvent, 1, 0)) AS ?branchesDeleted)
(SUM(IF(?type = gh:PullRequestEvent, 1, 0)) AS ?prEvents)
WHERE {
?ev gh:repo <https://github.com/caviri/rete> ; a ?type ; prov:atTime ?t .
BIND(day(?t) AS ?day)
} GROUP BY ?day ORDER BY ?day