Skip to content

Instantly share code, notes, and snippets.

View slpsys's full-sized avatar
💭
💯

Marc Bollinger slpsys

💭
💯
View GitHub Profile
class Player
private_class_method :new
class << self
def one ; 1 ; end
def two ; 2 ; end
end
end
class TTTEngine
@slpsys
slpsys / 1-1
Created January 7, 2019 23:57
101 1-on-1 questions script
#!/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:
#
# https://jasonevanish.com/2014/05/29/101-questions-to-ask-in-1-on-1s/
# Number of questions to ask
NUM_QUESTIONS=3
@slpsys
slpsys / keybase.md
Created July 18, 2018 22:26
keybase.md

Keybase proof

I hereby claim:

  • I am slpsys on github.
  • I am slpsys (https://keybase.io/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
slpsys / crap_tables.sql
Last active May 4, 2018 20:03
Query large (20GB on-cluster, for us) Redshift tables that are missing sort keys or are not diststyle key
SELECT
TRIM(pgn.nspname) AS schema,
TRIM(a.name) 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
FROM
(
SELECT db_id, id, name, SUM(rows) AS rows
@slpsys
slpsys / redshift_sort_key_filter.md
Last active November 26, 2017 17:39
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
slpsys / gist:198704b444fce38cff88dea6b9f0dbc7
Created February 25, 2017 20:21
Broadside config for load-balanced service, with preconfigured ELB named 'redshift-console-elb'
Broadside.configure do |config|
config.application = 'redshift_console'
config.default_docker_image = # image location
config.aws.ecs_default_cluster = # cluster name
config.targets = {
production_web: {
scale: 1,
env_file: '.env.production',
service_config: {
role: 'ecsServiceRole',
@slpsys
slpsys / RuntimeTypes.scala
Created July 13, 2016 17:10
Wrangling the type system _and_ getting runtime type info
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
slpsys / party.sh
Last active July 28, 2017 00:34
On a Mac, prerequisite is `brew install brightness`
#!/bin/bash
i=0
step=0.1
while true
do
b=$(echo "scale=3;(s($i)+1)*0.5" | bc -l)
brightness $b

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

Synopsis

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