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
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 / gist:198704b444fce38cff88dea6b9f0dbc7
Created Feb 25, 2017
Broadside config for load-balanced service, with preconfigured ELB named 'redshift-console-elb'
View gist:198704b444fce38cff88dea6b9f0dbc7
Broadside.configure do |config|
config.application = 'redshift_console'
config.default_docker_image = # image location = # cluster name
config.targets = {
production_web: {
scale: 1,
env_file: '.env.production',
service_config: {
role: 'ecsServiceRole',
slpsys / RuntimeTypes.scala
Created Jul 13, 2016
Wrangling the type system _and_ getting runtime type info
View RuntimeTypes.scala
import scala.reflect.runtime.{universe => ru}
// Trivial class hierarchy
class NotionalObject
class Car extends NotionalObject
class Dog extends NotionalObject
// Not part of the hierarchy
class AbstractExpressionism
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
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