Skip to content

Instantly share code, notes, and snippets.


Marc Bollinger slpsys

View GitHub Profile
View tic_tac_toe.rb
class Player
private_class_method :new
class << self
def one ; 1 ; end
def two ; 2 ; end
class TTTEngine
slpsys / 1-1
Created Jan 7, 2019
101 1-on-1 questions script
View 1-1
#!/bin/bash -ew
# Note that the question file accompanying this script came from
# Jason Evanish's excellent blog post, the original text of which can
# be which can be found here:
# Number of questions to ask

Keybase proof

I hereby claim:

  • I am slpsys on github.
  • I am slpsys ( on keybase.
  • I have a public key whose fingerprint is 8CFC 55BC E288 6D63 FFD7 499F 1B05 8607 4149 659D

To claim this, I am signing this object:

slpsys / crap_tables.sql
Last active May 4, 2018
Query large (20GB on-cluster, for us) Redshift tables that are missing sort keys or are not diststyle key
View crap_tables.sql
TRIM(pgn.nspname) AS schema,
TRIM( AS table,
CASE WHEN pgc.reldiststyle != 1 AND ti.sortkey_num = 0 THEN 'DISTSTYLE NOT KEY AND NO SORTKEY (TABLE IS GARBAGE)'
WHEN pgc.reldiststyle != 1 THEN 'DISTSTYLE NOT KEY'
WHEN ti.sortkey_num = 0 THEN 'NO SORTKEY'
END as issue
SELECT db_id, id, name, SUM(rows) AS rows
View Strangeloop Day 1 Notes.markdown

Keynote, "I See What You Mean" by Peter Alvaro



5/5. This is pretty academic, but it's pretty great, too. It starts with datalog, which heavily inspires his project Dedalus; there's a way better dissection of this talk here.

"Managing Containers at Scale with CoreOS and Kubernetes" by Kelsey Hightower

slpsys / bootstrap.sql
Last active Dec 18, 2017
Schema + sample data for regs / subs over time SQL question
View bootstrap.sql
# Drop the Coderpad default tables
drop table if exists alerts;
drop table if exists departments;
drop table if exists employees;
drop table if exists employees_projects;
drop table if exists projects;
drop table if exists sales;
drop table if exists signup_flow_events;
drop table if exists stores;
drop table if exists products;
slpsys / fizzBuzzStream.scala
Last active Dec 12, 2017
Because always moar.
View fizzBuzzStream.scala
object fizzBuzzStream extends App {
type FizzBuffer = (Int, String)
def fb(b: FizzBuffer)(i:Int, s:String) = if (b._1 % i == 0) { new FizzBuffer(b._1, b._2 + s) } else { b }
def fizz = fb(_:FizzBuffer)(3, "Fizz")
def buzz = fb(_:FizzBuffer)(5, "Buzz")
def fizzBuzz = fizz andThen buzz
val naturals: Stream[Int] = 1 #:: {n => n + 1}
val fizzyStream = => fizzBuzz(new FizzBuffer(n, "")))
slpsys /
Last active Nov 26, 2017
AWS Redshift - Filtering on a sort key

Execution plans

EXTRACT (YEAR FROM date_field) for a given year:

warehouse=# explain select count(*) from views.gamesave where EXTRACT (YEAR FROM event_created_at) = 2016;
                                 QUERY PLAN
 XN Aggregate  (cost=8152608.99..8152608.99 rows=1 width=0)
   ->  XN Seq Scan on gamesave  (cost=0.00..8145820.80 rows=2715274 width=0)
slpsys /
Last active Jul 28, 2017
On a Mac, prerequisite is `brew install brightness`
while true
b=$(echo "scale=3;(s($i)+1)*0.5" | bc -l)
brightness $b
You can’t perform that action at this time.