Apollo Clark apolloclark

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL

Bash Cheatsheet

The following is a list of various Bash commands which I use on a regular basis. It's not exhaustive, just a simple "getting started", and collection of useful commands. Anything between the brackets "<>" should be replaced.

Collection of various Bash commands:

AWS CLI Cheatsheet

http://docs.aws.amazon.com/IAM/latest/UserGuide/best-practices.html https://www.youtube.com/watch?v=_wiGpBQGCjU

	<VirtualHost *>
	WSGIApplicationGroup %{GLOBAL}


	# Setup Python for the App1
	WSGIDaemonProcess app1 user=www-data group=www-data threads=5
	WSGIScriptAlias /app1 /var/www/app1/app1.wsgi
	<Directory /var/www/app1>
	Order deny,allow
	Allow from all

	# required distro packages
	sudo apt-get -y install nmap curl libcurl3-dev rbenv libyaml-dev libxml2-dev libxslt-dev ruby1.9.1-dev

	# Install Gauntlt
	sudo gem install gauntlt

	# install XMLLint, tidy
	# @see http://datascienceatthecommandline.com/
	sudo apt-get install -y libxml2-utils tidy


	# add video mode
	VBoxManage setextradata "VM_NAME" "CustomVideoMode1" "1280x720x32"

	# set video mode
	VBoxManage controlvm "VM_NAME" setvideomodehint 1280 720 32

	#!/bin/bash
	# @see https://gorails.com/setup/ubuntu/15.10

	# update, install git
	export DEBIAN_FRONTEND="noninteractive"
	sudo apt-get update
	sudo apt-get install -y git-core build-essential libssl-dev libreadline-dev \
	libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev \
	libcurl4-openssl-dev python-software-properties libffi-dev zlib1g-dev

	# list repos
	sudo apt-cache policy

	# add repo
	sudo add-apt-repository "deb http://us.archive.ubuntu.com/ubuntu/ saucy universe multiverse"

	# remove repo
	sudo add-apt-repository --remove <ppa:whatever/ppa>

	# list package version available
	pip install --no-deps --no-install <package_name> -v

	# create an account, create an app
	# @see https://apps.twitter.com/

	# retrieve the access tokens
	# @see https://dev.twitter.com/oauth/reference/post/oauth2/token

	# create the file ~/twitter_api
	nano ~/twitter_api
	Authorization: OAuth oauth_consumer_key="XXXXXX", oauth_nonce="11111111", oauth_signature="XXXXXX", oauth_signature_method="HMAC-SHA1", oauth_timestamp="1450728725", oauth_token="99999-XXXXXX", oauth_version="1.0"