Skip to content

Instantly share code, notes, and snippets.

Avatar

Álvaro Hernández Tortosa ahachete

View GitHub Profile
View keybase.md

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:

View Stampede-GithuQuery-PostgreSQL-F
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;
View Stampede-GithuQuery-PostgreSQL-E
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
View Stampede-GithuQuery-PostgreSQL-D
SELECT action_s, count(*)
FROM github.events_payload
WHERE action_s IS NOT NULL
GROUP BY action_s
ORDER BY count DESC;
View Stampede-GithuQuery-PostgreSQL-C
SELECT events.type_s, count(*)
FROM github.events AS events
JOIN github.events_actor AS actor ON (events.did = actor.did)
GROUP BY type_s
ORDER BY count DESC;
View Stampede-GithuQuery-PostgreSQL-B
SELECT type_s, count(*)
FROM github.events
GROUP BY type_s
ORDER BY count desc;
View Stampede-GithuQuery-PostgreSQL-A
SELECT repo.name_s, count(*)
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 = 'IssuesEvent' AND payload.action_s = 'opened'
GROUP BY repo.name_s
ORDER BY count desc;
View Stampede-GithubQuery-MongoDB-F
db.events.aggregate(
[
{ $match: { "type": "PushEvent", "payload.size": { $gt : 2 } } },
{ $group: { _id: "$repo.name", avg: { $avg: "$payload.size" } } },
{ $sort: { avg: -1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);
View Stampede-GithubQuery-MongoDB-E
db.events.aggregate(
[
{ $match: { "type": "PushEvent" } },
{ $project: { "repo.name": 1, "actor.login": 1 } },
{ $group:
{
_id: "$repo.name",
actor: { $first: "$actor.login"},
count: { $sum: 1 }
}
View Stampede-GithubQuery-MongoDB-D
db.events.aggregate(
[
{ $match: { "payload.action": { $exists: true } } },
{ $group: { _id: "$payload.action", total: { $sum: 1 } } },
{ $sort: { total: 1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);