Caleb Brown kayluhb

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)

Installing and Setting a Timezone database

We're using Rails 4, PostgreSQL 9.3.4, and PostGIS 2.1.2.

Creating a Postgis enabled Postgresql template

createdb -E UTF8 template_postgis
createlang -d template_postgis plpgsq
psql -d template_postgis -c "CREATE EXTENSION postgis WITH SCHEMA public;"

Let's Encrypt on Ubuntu 14.04, nginx with webroot auth

This document details how I setup LE on my server. Firstly, install the client as described on http://letsencrypt.readthedocs.org/en/latest/using.html and make sure you can execute it. I put it in /root/letsencrypt.

As it is not possible to change the ports used for the standalone authenticator and I already have a nginx running on port 80/443, I opted to use the webroot method for each of my domains (note that LE does not issue wildcard certificates by design, so you probably want to get a cert for www.example.com and example.com).

Configuration

For this, I placed config files into etc/letsencrypt/configs, named after <domain>.conf. The files are simple:

	@-webkit-keyframes killerdiller {
	from { -webkit-transform: rotate(-45deg); }
	to { -webkit-transform: rotate(360deg); }
	}
	body
	{
	-webkit-animation: killerdiller 0.5s infinite;
	-webkit-animation-timing-function: linear;
	}

	Steps to install and run PostgreSQL 9.2 using Homebrew (Mac OS X)
	(if you aren't using version 9.1.5, change line 6 with the correct version)

	1. launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
	2. mv /usr/local/var/postgres /usr/local/var/postgres91
	3. brew update
	4. brew upgrade postgresql
	5. initdb /usr/local/var/postgres -E utf8
	6. pg_upgrade -b /usr/local/Cellar/postgresql/9.1.5/bin -B /usr/local/Cellar/postgresql/9.2.0/bin -d /usr/local/var/postgres91 -D /usr/local/var/postgres
	7. cp /usr/local/Cellar/postgresql/9.2.0/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/

	module Draper
	class CollectionDecorator
	delegate :current_page, :total_pages, :limit_value
	end
	end

	(function (window) {
	var transitions = {
	'transition': 'transitionend',
	'WebkitTransition': 'webkitTransitionEnd',
	'MozTransition': 'transitionend',
	'OTransition': 'otransitionend'
	},
	elem = document.createElement('div');

	for(var t in transitions){

	require 'openssl'
	require 'digest/sha1'
	require 'base64'
	require 'json'

	def go_demo!

	key = Digest::SHA1.hexdigest("clave1")[0..15] # 16bytes => 128bits
	iv = 'clave2 con chicha'[0..15] # 16bytes forced
	data = { esto: 'es', un: 'hash', en: 'ruby' }

	Drop in replace functions for setTimeout() & setInterval() that
	make use of requestAnimationFrame() for performance where available