Stephan Fitzpatrick knowsuchagency

This guide assumes that you recently run brew upgrade postgresql and discovered to your dismay that you accidentally bumped from one major version to another: say 9.3.x to 9.4.x. Yes, that is a major version bump in PG land.

First let's check something.

brew info postgresql

The top of what gets printed as a result is the most important:

Channels Are Not Enough

... or Why Pipelining Is Not That Easy

Golang Concurrency Patterns for brave and smart.

By @kachayev

Intro

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)

	import aiohttp
	import asyncio

	async def get_body(url):
	response = await aiohttp.request('GET', url)
	raw_html = await response.read()
	return raw_html

	async def main():
	# run them sequentially (but the loop can do other stuff in the meanwhile)

	// General hints on defining types with constraints or invariants
	//
	// Just as in C#, use a private constructor
	// and expose "factory" methods that enforce the constraints
	//
	// In F#, only classes can have private constructors with public members.
	//
	// If you want to use the record and DU types, the whole type becomes
	// private, which means that you also need to provide:
	// * a constructor function ("create").

	# Hello, and welcome to makefile basics.
	#
	# You will learn why `make` is so great, and why, despite its "weird" syntax,
	# it is actually a highly expressive, efficient, and powerful way to build
	# programs.
	#
	# Once you're done here, go to
	# http://www.gnu.org/software/make/manual/make.html
	# to learn SOOOO much more.

	#!/bin/bash
	#####################################################
	# Name: Bash CheatSheet for Mac OSX
	#
	# A little overlook of the Bash basics
	#
	# Usage:
	#
	# Author: J. Le Coupanec
	# Date: 2014/11/04

	# IMPORTANT SETUP INSTRUCTIONS:
	#
	# 1. Go to http://www.dropbox.com/developers/apps (log in if necessary)
	# 2. Select "Create App"
	# 3. Select the following settings:
	# * "Dropbox API app"
	# * "Files and datastores"
	# * "(No) My app needs access to files already on Dropbox"
	# * "All file types"
	# * (Choose any app name)

	import json
	import geojson
	from shapely.geometry import shape

	o = {
	"coordinates": [[[23.314208, 37.768469], [24.039306, 37.768469], [24.039306, 38.214372], [23.314208, 38.214372], [23.314208, 37.768469]]],
	"type": "Polygon"
	}

	s = json.dumps(o)

	# -- coding: utf-8 --
	# In order to run this script, you'll need to
	# have both py.test and six installed.
	# Assuming you have pip, in a virtualenv just
	# type at the command-line:
	#
	# pip install pytest six
	#
	# To run it, just type:
	#