Skip to content

Instantly share code, notes, and snippets.

Avatar

Patrick DeVivo patrickdevivo

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

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

@patrickdevivo
patrickdevivo / README.md
Last active Oct 7, 2020
Contributor email domain distributions
View README.md

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
SELECT
count(*),
substr(author_email, instr(author_email, '@')+1) AS email_domain -- https://sqlite.org/lang_corefunc.html
FROM commits
WHERE parent_count < 2 -- ignore merge commits
GROUP BY email_domain
ORDER BY count(*) DESC