☁️

Dan Kohn dankohn

☁️

General Manager of LF Public Health. VP, Strategic Programs of CNCF. Senior Advisor to the Linux Foundation's Core Infrastructure Initiative. ☁️👨🏼‍

dankohn / FizzBuzz

Last active February 7, 2018 19:56

puts 1.upto(100).map { |n| "#{'Fizz' if n%3==0}#{'Buzz' if n%5==0}".presence || n }

dankohn / coredns.txt

Created December 20, 2017 21:11


	OOOO
	OOOOOOOOOO
	ZZOOOOOOOOOOO
	ZZZZZOOOOOOOOOOO
	ZZZZZZZZZOOOOOOOOOO
	ZZZZZZZZZZZOOOOOOOOOOO $$$$$$
	ZZZZZZZZZZZZZZZOOOOOOOOOOO $$$$$$$$$
	ZZZZZZZZZZZZZZZZZZOOOOOOOOOOO$$$$$$$$$$$$$
	ZZZZZZZZZZZZZZZZZZ ~OOOOOOMMM$$$$$$$$$$$$

dankohn / danserve.rb

Last active December 19, 2017 17:40

Simple key-value server

	# frozen_string_literal: true

	class Server
	def get(query)
	respond "db: #{@db}"
	return unless (value = query['key'])
	if (lookup = @db[value])
	respond "successful lookup: #{value} => #{lookup}"
	else respond "failed lookup: no entry for #{value}"
	end

dankohn / commits_and_authors.sql

Created February 26, 2017 08:19

Commits and authors

	SELECT
	repo.name AS repository,
	COUNT(repo.name) AS commits,
	EXACT_COUNT_DISTINCT(actor.login) AS committers,
	EXACT_COUNT_DISTINCT(JSON_EXTRACT(payload, '$.commits[0].author.email')) AS authors
	FROM
	[githubarchive:year.2016]
	WHERE
	type IN ("PushEvent")
	GROUP BY

dankohn / project_commits.sql

Created February 26, 2017 06:32

Project commits

	SELECT
	repo_name AS repository,
	EXACT_COUNT_DISTINCT(author.name) AS authors,
	EXACT_COUNT_DISTINCT(committer.name) AS committers,
	COUNT(*) AS commits
	FROM
	[bigquery-public-data:github_repos.commits]
	WHERE
	repo_name IN ( "torvalds/linux",
	"facebook/react-native",

dankohn / by_commit.sql

Created February 26, 2017 06:06

By commit

	SELECT
	repo_name AS repository,
	EXACT_COUNT_DISTINCT(author.name) AS authors,
	EXACT_COUNT_DISTINCT(committer.name) AS committers,
	COUNT(*) AS commits
	FROM
	[bigquery-public-data:github_repos.commits]
	WHERE
	committer.date >= TIMESTAMP("2016-01-01 00:00:00")
	AND committer.date < TIMESTAMP("2017-01-01 00:00:00")

dankohn / pull_requests.sql

Last active May 21, 2017 00:49

Pull requests, based on https://blog.jessfraz.com/post/analyzing-github-pull-request-data-with-big-query/

	SELECT
	repo.name AS repository,
	COUNT(*) AS pull_requests,
	EXACT_COUNT_DISTINCT(actor.login) AS contributors
	FROM
	[githubarchive:year.2016]
	WHERE
	type IN ( 'PullRequestEvent')
	AND JSON_EXTRACT(payload, '$.action') IN ('"opened"')
	GROUP BY

dankohn / issues.sql

Last active February 26, 2017 05:11

	SELECT
	repo.name,
	ROUND(COUNT(*)/EXACT_COUNT_DISTINCT(actor.login),2) comments_per_author,
	EXACT_COUNT_DISTINCT(actor.login ) authors,
	COUNT(*) comments
	FROM
	[githubarchive:year.2016]
	WHERE
	type IN ('IssueCommentEvent')
	AND actor.login NOT IN (

dankohn / over_10_contributors.sql

Last active February 26, 2017 05:05

More than 10 contributors

	SELECT
	repo.name AS repository,
	COUNT(repo.name) AS commits,
	EXACT_COUNT_DISTINCT(actor.login) AS contributors
	FROM
	[githubarchive:year.2016]
	WHERE
	type IN ("PushEvent")
	GROUP BY
	repository

dankohn / commits.sql

Created February 26, 2017 03:07

GitHub Commits

	SELECT
	repo.name AS repository,
	COUNT(repo.name) AS commits,
	EXACT_COUNT_DISTINCT(actor.login) AS contributors
	FROM
	[githubarchive:year.2016]
	WHERE
	type IN ("PushEvent")
	GROUP BY
	repository