Gregory Orton ortonomy

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Version: 1.9.8

Platform: x86_64

First, install or update to the latest system software.

sudo apt-get update
sudo apt-get install build-essential chrpath libssl-dev libxft-dev

People

start new:

tmux

start new with session name:

tmux new -s myname

	# Adapted for Mac OSX from http://christian.gen.co/macbook-developer-setup/
	# and http://jeroenjanssens.com/2013/08/16/quickly-navigate-your-filesystem-from-the-command-line.html
	export MARKPATH=$HOME/.marks
	function jump {
	cd -P $MARKPATH/$1 2>/dev/null \|\| echo "No such mark: $1"
	}
	function mark {
	mkdir -p $MARKPATH; ln -s $(pwd) $MARKPATH/$1
	}
	function unmark {

	var myCanvasView = new View({
	x:100, y:100,
	width:200, height:200
	})

	// Add a nice background color so we see it
	myCanvasView.style.backgroundColor = "rgba(255,0,0,.5)"


	// This is the tricky bit, we create a canvas element (so we have a reference to it) and insert it into the view

	[
	{"group":"US (Common)",
	"zones":[
	{"value":"America/Puerto_Rico","name":"Puerto Rico (Atlantic)"},
	{"value":"America/New_York","name":"New York (Eastern)"},
	{"value":"America/Chicago","name":"Chicago (Central)"},
	{"value":"America/Denver","name":"Denver (Mountain)"},
	{"value":"America/Phoenix","name":"Phoenix (MST)"},
	{"value":"America/Los_Angeles","name":"Los Angeles (Pacific)"},
	{"value":"America/Anchorage","name":"Anchorage (Alaska)"},

	git branch -m old_branch new_branch # Rename branch locally
	git push origin :old_branch # Delete the old branch
	git push --set-upstream origin new_branch # Push the new branch, set local branch to track the new remote