Peter H. peterhil

How to set up stress-free SSL on an OS X development machine

One of the best ways to reduce complexity (read: stress) in web development is to minimize the differences between your development and production environments. After being frustrated by attempts to unify the approach to SSL on my local machine and in production, I searched for a workflow that would make the protocol invisible to me between all environments.

Most workflows make the following compromises:

Use HTTPS in production but HTTP locally. This is annoying because it makes the environments inconsistent, and the protocol choices leak up into the stack. For example, your web application needs to understand the underlying protocol when using the secure flag for cookies. If you don't get this right, your HTTP development server won't be able to read the cookies it writes, or worse, your HTTPS production server could pass sensitive cookies over an insecure connection.
Use production SSL certificates locally. This is annoying

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)

	DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE
	Version 2, December 2004

	Copyright (C) 2011 YOUR_NAME_HERE <YOUR_URL_HERE>

	Everyone is permitted to copy and distribute verbatim or modified
	copies of this license document, and changing it is allowed as long
	as the name is changed.

	DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE

	#!/usr/bin/env python
	# -- coding: utf-8 --

	import sys
	import math

	from PyQt4 import QtGui, QtCore


	def binomial(i, n):

	# GNU Screen - main configuration file
	# All other .screenrc files will source this file to inherit settings.
	# Author: Christian Wills - [email protected]

	# Allow bold colors - necessary for some reason
	attrcolor b ".I"

	# Tell screen how to set colors. AB = background, AF=foreground
	termcapinfo xterm 'Co#256:AB=\E[48;5;%dm:AF=\E[38;5;%dm'

	{------------------------------------------------------------------------------
	reactive-banana

	Implementation of an "industry strength" game loop with fixed time step
	and variable fps.

	See also http://gafferongames.com/game-physics/fix-your-timestep/
	-------------------------------------------------------------------------------}
	{-# LANGUAGE NoMonomorphismRestriction #-}
	module Main where

	# coding=UTF-8
	import nltk
	from nltk.corpus import brown

	# This is a fast and simple noun phrase extractor (based on NLTK)
	# Feel free to use it, just keep a link back to this post
	# http://thetokenizer.com/2013/05/09/efficient-way-to-extract-the-main-topics-of-a-sentence/
	# Create by Shlomi Babluki
	# May, 2013

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

	# Public domain.
	# 2013, Pyry Jahkola.

	from __future__ import print_function
	import sys, time

	def progress(iterable, n=None, **kwargs):

	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
	<input id="file" type="file" accept="image/*" />
	<br/>

	<h2>As read:</h2>
	<img id="placeholder1" width=300/><br/>
	<h2>Rotated by exif data:</h2>
	<img id="placeholder2" width=300/>

	<script>