🪞 This repository, watching itself grow — day by day

SELECT ?day (COUNT(*) AS ?events)
       (SUM(IF(?type = gh:PushEvent, 1, 0)) AS ?pushes)
       (SUM(IF(?type = gh:CreateEvent, 1, 0)) AS ?branche…
       (SUM(IF(?type = gh:DeleteEvent, 1, 0)) AS ?branche…
       (SUM(IF(?type = gh:PullRequestEvent, 1, 0)) AS ?pr…
WHERE {

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → 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

rete playground · documentation · github.com/caviri/rete