ahachete

WITH distinct_commits AS (
        SELECT	DISTINCT repo.name_s, actor.login_s
        FROM	github.events AS events 
                INNER JOIN github.events_actor AS actor ON (events.did = actor.did)
                INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
        WHERE	events.type_s = 'PushEvent' 
)
SELECT		name_s, count(*) 
FROM		distinct_commits
GROUP BY	name_s

ahachete

SELECT		repo.name_s, avg(payload.size_i)
FROM		github.events AS events 
        		INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
        		INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
WHERE		events.type_s = 'PushEvent' AND payload.size_i > 2
GROUP BY	repo.name_s
ORDER BY 	avg DESC;

ahachete

Keybase proof

I hereby claim:

• I am ahachete on github.
• I am ahachete (https://keybase.io/ahachete) on keybase.
• I have a public key ASAuFf6e-VrTMJzofLvVKSpuaLc0eOnPytwGuPzK5XO3gwo

To claim this, I am signing this object:

ahachete

#!/bin/sh

TOKEN=$( curl -s "https://auth.docker.io/token?service=registry.docker.io&scope=repository:library/postgres:pull" \
    	| jq -r .token )

MANIFEST_INDEX=$( curl -s -H "Authorization: Bearer $TOKEN" \
    	https://registry-1.docker.io/v2/library/postgres/manifests/latest )

AMD64_MANIFEST_DIGEST=$( echo $MANIFEST_INDEX \
    	|jq -r '.manifests[] | select(.platform.architecture == "amd64") .digest' )