patrickdevivo

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

patrickdevivo

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

patrickdevivo

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

patrickdevivo

const names = ["world", "patrick", "deno", "adhoc"]

names.forEach(n => console.log(`hello, ${n}!`))

patrickdevivo

         _nnnn_                      
        dGGGGMMb     ,""""""""""""""""""""""""""""".
       @p~qp~~qMb    | // TODO make this better 🎉 |
       M|@||@) M|   _;.............................'
       @,----.JM| -'
      JS^\__/  qKL
     dZP        qKRb
    dZP          qKKb
   fZP            SMMb
   HZM            MMMM

patrickdevivo

Verifying my Blockstack ID is secured with the address 1NKAeaGUag7tpGxpy6unSrAWRZhXJe5JQx https://explorer.blockstack.org/address/1NKAeaGUag7tpGxpy6unSrAWRZhXJe5JQx

patrickdevivo

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

patrickdevivo

;;; Fibonacci Sequence

	SA	0x80
	COPY	%rA
	SA	0x00
	COPY	%rB
	STOR	%rB	%rA	; set F(0)=0
	
	SA	0x81
	COPY	%rA

patrickdevivo

;;; Sum an array

	;; Load 0 (where iterator initializes) into %rB
	SA	0x01
	COPY	%rB

	;; Load n (length of array, also number of iterations when summing the array) into %rA
cond:	LLAC	n
	COPY	%rD		; %rD = &n
	LOAD	%rA	%rD	; %rA = n

patrickdevivo

csv = require 'csv'
_ = require 'underscore'
Table = require 'cli-table'

class Class
	constructor: (@code, @sect, @title, @teacher, @room, @capacity, @grade) ->

classes = {}
schedule = {
	M: [[], [], [], [], [], [], [], []] # DAY: period[classess[]]