abelmartin

Spell check entire codebase

Requires aspell. Install using brew install aspell on Mac OS X.

From STDIN

cat *.txt | aspell -l EN-US --mode=tex list

Whole directory

abelmartin

KEYBINDINGS
       byobu keybindings can be user defined in /usr/share/byobu/keybindings/ (or within .screenrc if byobu-export was used). The  common  key  bindings
       are:

       F2 - Create a new window

       F3 - Move to previous window

       F4 - Move to next window

abelmartin

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

abelmartin

MongoDB cheat sheet

Overview

Overview

MongoDB is a document database that provides high performance, high availability, and easy scalability.

• Document Database

abelmartin

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

abelmartin

import requests, json
from collections import Counter

districts = json.loads(requests.get('http://public-crest.eveonline.com/districts/').text)['items']

systems = {}
constellations = {}
s_times = {}
c_times = {}

abelmartin

def output name=((default=true); "caius")
  puts "name: #{name.inspect}"
  puts "default: #{default.inspect}"
end

output
# >> name: "caius"
# >> default: true

output "avdi"

abelmartin

#!/usr/bin/env ruby
# encoding: utf-8

# irb3 - Runs an IRB-esque prompt (but it's NOT really IRB!) over multiple
#        versions of Ruby at once (using RVM)
#        
#        By Peter Cooper, BSD licensed
#
#        Main dependency is term-ansicolor for each impl:
#          rvm exec gem install term-ansicolor