Skip to content

Instantly share code, notes, and snippets.

schacon / cohort.sql
Last active Nov 3, 2020
Cohort Month Base Values for BigQuery
View cohort.sql
select month, months_out from (
select month,
from UNNEST(
) as month
) CROSS JOIN UNNEST(months) as months_out

Keybase proof

I hereby claim:

  • I am schacon on github.
  • I am scottchacon ( on keybase.
  • I have a public key ASAcTJsFnTw59Ncpg1Bax0VQ1yH1B3N2MQaDHsadrT95aAo

To claim this, I am signing this object:

schacon / gist:793c8fdea738fd3d04a7
Created Dec 18, 2014
crush and resize book images
View gist:793c8fdea738fd3d04a7
#! /usr/bin/env ruby
require 'rubygems'
require 'oily_png'
Dir.glob("book/**/*.png").each do |file|
puts file
image = ChunkyPNG::Image.from_file(file)
p image.width
p image.height
if image.width > 800 || image.height > 800
schacon / 0_reuse_code.js
Created Dec 3, 2013
Here are some things you can do with Gists in GistBox.
View 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
schacon / git-http-proto.txt
Created Jul 26, 2013
Git HTTP transport protocol documentation
View git-http-proto.txt
HTTP transfer protocols
Git supports two HTTP based transfer protocols. A "dumb" protocol
which requires only a standard HTTP server on the server end of the
connection, and a "smart" protocol which requires a Git aware CGI
(or server module). This document describes both protocols.
As a design feature smart clients can automatically upgrade "dumb"
protocol URLs to smart URLs. This permits all users to have the
schacon /
Created May 14, 2013
Andrew Raseij's PDF speech in 2005

Welcome to the second annual Personal Democracy Forum. It’s great to see so many familiar faces from last year’s forum, and to greet so many new folks who are here. It seems our blog-ads on Jeff Gannon’s website paid off.

We’re putting on our conference today in cooperation with the Continuing Education and Public Programs at the Graduate Center of the City University of New York. Thank you David Levine and your whole staff here at CUNY, you’ve been fantastic.

I also want to take a moment to thank the terrific and talented PDF staff for putting together a program interesting and provocative enough to get a room full of techies to put down their Berries and Treos for the better part of a day: Hart Hooton, Dawn Barber, Jen Vento, Isabel Walcott, and our executive editor, Micah Sifry. In particular, I’d like to single out Anthony Russomano and Elizabeth Caputo for their tireless efforts to make today a success

And a special thanks to our distinguished group of sponsors: Google, Burson-Marsteller, Echoditto, E

schacon / gist:4550891
Created Jan 16, 2013
The keyboard shortcuts to know when you hook up your mac to present in keynote (for quicker lightning talks setup)
View gist:4550891
Mirror/unmirror displays: ⌘-F1 or ⌘-fn-1
Switch presenter display: x
View leap.json
"hands": [
"direction": [
"id": 3,
"palmNormal": [
schacon / upload.rb
Created Apr 16, 2012
ruby script to upload a file to GitHub downloads section
View upload.rb
#! /usr/bin/env ruby
# ruby upload.rb user pass user/repo file '(description)'
require 'json'
if ARGV.size < 4
puts "\nUSAGE: upload.rb [user] [pass] [user/repo] [filepath] ('description')"