alexmuller

#!/usr/bin/env ruby

# Output:
# TSV
# hits_date.tsv
# date, count, status, host, path

dates = [
  "2013-10-19",
  "2013-10-20",

philandstuff

russ garrett on postgres

• I like it as a default database when I don’t know what database I want to use

schemas

• I like schemas and I hate schemaless databases
• it’s useful to be able to enforce your schema before the data gets written to disk
  • rather than in your ORM!
  • CHECK constraints: ensure balance >= 0

schema changes often aren’t great

• this is why people don’t like schemas

rgarner

PSQL cheat sheet

Starting it (examples)

Command (shell)	Does this
psql	Starts psql connected to your own user's database
psql -d <database>	Starts psql connected to the given <database>
cat some.sql | psql -d <database>	Runs the SQL script in some.sql on <database>

mhl

#!/usr/bin/env python

import sys
import os
from subprocess import check_call
from lxml import etree

if len(sys.argv) != 2:
    print >> sys.stderr, "Usage: %s [EMX-FILE]" % (sys.argv[0])
    sys.exit(1)

ashb

#!/bin/bash -e

set -o pipefail


case "$1" in
  --list|-l)
    list_only=1
    ;;
  --dry-run|-n)

digitalronin

# Hub & GHI (assumes you have homebrew installed)
brew install hub  # https://github.com/github/hub
brew install ghi  # https://github.com/stephencelis/ghi

# You will need env vars like this: EDITOR=vim, GIT_EDITOR=vim

# Aliases
alias gch='git checkout'
alias prune-local-branches='git branch | grep -v master | xargs git branch -d'
alias push-branch='git push origin $(git rev-parse --abbrev-ref HEAD)'