Keybase proof
I hereby claim:
- I am newalexandria on github.
- I am newalexandria (https://keybase.io/newalexandria) on keybase.
- I have a public key ASC1Scdtf-36b4jiLY8AvgvFFqjVow1-Cnbiw43f6vzmjgo
To claim this, I am signing this object:
// | |
// Available variables: | |
// - Machine | |
// - interpret | |
// - assign | |
// - send | |
// - sendParent | |
// - spawn | |
// - raise | |
// - actions |
// Available variables: | |
// - Machine | |
// - interpret | |
// - assign | |
// - send | |
// - sendParent | |
// - spawn | |
// - raise | |
// - actions |
# this was provided by AWS reps | |
WITH base_skew AS ( | |
SELECT id as tbl FROM stv_tbl_perm GROUP BY id | |
HAVING SUM(rows) > (SELECT 1000000 * ( MAX(node) + 1) FROM stv_slices) | |
AND (MAX(rows) / (MIN(rows) + 1.0)) >= 2.0 | |
AND SUM(rows) <> (MAX(rows) * (SELECT MAX(node) + 1 FROM stv_slices)) | |
), | |
table_slices AS ( | |
SELECT t.slice, t.id, COUNT(b.blocknum) s_mb, COUNT(DISTINCT col) * COUNT(DISTINCT unsorted) ss_mb |
#!/usr/bin/python | |
"""AWS EC2 SSH config Generator.""" | |
# edit these: | |
# * path_to_config | |
# * path_to_ssh_key | |
# remember the path_to_config must be write-able by the script | |
# before running, install aws_cli and login with your credentials | |
# then move to your .ssh folder and in your .ssh/config file |
I hereby claim:
To claim this, I am signing this object:
#!/usr/bin/python | |
# from https://www.reddit.com/r/technology/comments/43fi39/i_set_up_my_raspberry_pi_to_automatically_tweet/ | |
import os | |
import sys | |
import csv | |
import datetime | |
import time | |
import twitter | |
z
# with reference to rendered output but the OP | |
# https://www.reddit.com/r/mathpics/comments/3yzu77/heres_an_animated_version_of_that_circular/ | |
# and a video guide | |
# https://www.youtube.com/watch?v=qhbuKbxJsk8 | |
require "rmagick" | |
RESOLUTION = 800 | |
def localToGlobalCoords(n) |
#!/usr/bin/env ruby | |
bl = `brew list`.split ;1 | |
bdl = bl.reduce({}) {|h, pkg| h.merge({pkg => `brew deps #{pkg}`.split }) } ;1 | |
bi = bl - bdl.values.flatten.sort | |
File.open('apps_brew.txt', 'w') {|f| f.write bi.join("\n") } |
File.open(".vimrc","a") do |f| | |
f.write File.readlines('.gitmodules') | |
.map(&:strip) | |
# remove extras | |
.reject do |l| | |
l.scan('[').any? || # submodule defs | |
l.scan(/^path/).any? || # submodules paths | |
l.empty? # blank lines | |
end | |
# remap URLs to user/repo names |