Gretchen Leigh Miller gretchenleighmiller

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)

	#!/bin/bash

	AWS_DEFAULT_REGION="ap-northeast-1"
	AWS_ACCESS_KEY_ID="YOUR ACCESS KEY HERE"
	AWS_SECRET_ACCESS_KEY="YOUR SECRET ACCESS KEY HERE"

	INSTANCE_ID_URL="http://169.254.169.254/latest/meta-data/instance-id"
	INSTANCE_ID=$(curl -s ${INSTANCE_ID_URL})

	SERVER_STATUS_URL="http://localhost/php-fpm-status"

	# -- coding: utf-8 --
	import json
	import urllib2
	from M2Crypto import X509
	from base64 import b64decode
	from M2Crypto.Err import M2CryptoError

	SNS_MESSAGE_TYPE_SUB_NOTIFICATION = "SubscriptionConfirmation"
	SNS_MESSAGE_TYPE_NOTIFICATION = "Notification"
	SNS_MESSAGE_TYPE_UNSUB_NOTIFICATION = "UnsubscribeConfirmation"

	;SMBDIS.ASM - A COMPREHENSIVE SUPER MARIO BROS. DISASSEMBLY
	;by doppelganger (doppelheathen@gmail.com)

	;This file is provided for your own use as-is. It will require the character rom data
	;and an iNES file header to get it to work.

	;There are so many people I have to thank for this, that taking all the credit for
	;myself would be an unforgivable act of arrogance. Without their help this would
	;probably not be possible. So I thank all the peeps in the nesdev scene whose insight into
	;the 6502 and the NES helped me learn how it works (you guys know who you are, there's no