Skip to content

Instantly share code, notes, and snippets.


Patrick DeVivo patrickdevivo

View GitHub Profile
patrickdevivo / b
Created Nov 2, 2017
blockstack verify
View b
Verifying my Blockstack ID is secured with the address 1NKAeaGUag7tpGxpy6unSrAWRZhXJe5JQx
View deno-hello-world.ts
const names = ["world", "patrick", "deno", "adhoc"]
names.forEach(n => console.log(`hello, ${n}!`))
View tux_todo.txt
dGGGGMMb ,""""""""""""""""""""""""""""".
@p~qp~~qMb | // TODO make this better 🎉 |
M|@||@) M| _;.............................'
@,----.JM| -'
JS^\__/ qKL
dZP qKRb
dZP qKKb

Using gitqlite, query for percentage of commit count by author (in this case in facebook/react). Limit to top 25, include a "chart"

patrickdevivo /
Last active Oct 7, 2020
Contributor email domain distributions

Contributors by Email Domain

AskGit is a tool looking for more (interesting) use cases. This gist takes a look at the email domains of contributors to two major open source code bases (Linux and Kubernetes). askgit-query.sql can be piped into the askgit command to produce the output in k8s-SHA.txt and linux-SHA.txt

  • Commit Count is the total number of commits by contributors with an email address from Domain
  • Unique Emails is the number of unique contributors with an email from Domain
  • Domain is the email domain
View commits_by_email_domain.sql
substr(author_email, instr(author_email, '@')+1) AS email_domain --
FROM commits
WHERE parent_count < 2 -- ignore merge commits
GROUP BY email_domain
ORDER BY count(*) DESC