NewAlexandria

# 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

NewAlexandria

# Ruby class for automating 'git bisect' with Rails tests
class BisectTest
  def initialize(files_to_test: , last_good_commit: )
    @files_to_test = files_to_test.is_a?(Array) ? files_to_test : [files_to_test]
    @last_good_commit = last_good_commit
  end

  # Function to run the test suite and return true if the test passed, false if it failed
  def test_command
    "bundle exec rails test #{@files_to_test.join(' ')}"

NewAlexandria

#!/usr/bin/ruby

require 'json'

seg_rx = /segment[0-9]+\.ts/
file_num_rx = /^segment([0-9]+)/
pwd = "#{`pwd`.strip}"
clean_sources = false
clean_joins = false

NewAlexandria

  // Available variables:
  // - Machine
  // - interpret
  // - assign
  // - send
  // - sendParent
  // - spawn
  // - raise
  // - actions

NewAlexandria

//
  // Available variables:
  // - Machine
  // - interpret
  // - assign
  // - send
  // - sendParent
  // - spawn
  // - raise
  // - actions

NewAlexandria

  // Available variables:
  // - Machine
  // - interpret
  // - assign
  // - send
  // - sendParent
  // - spawn
  // - raise
  // - actions

NewAlexandria

#!/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

NewAlexandria

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:

NewAlexandria

#!/usr/bin/env ruby                                                                                                                                                                                         
require 'fileutils'                                                                                                                                                                                         
                                                                                                                                                                                                            
# these are the folders containing all your images                                                                                                                                                          
if ARGV.size == 2                                                                                                                                                                                           

NewAlexandria

#!/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