Dexter Tad-y dexterbt1

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

PostgreSQL & PostGIS Cheatsheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.

	# Based on post from: https://snipt.net/chrisdpratt/symmetrical-manytomany-filter-horizontal-in-django-admin/#L-26
	# Only reposting to avoid loosing it.

	"""
	When adding a many-to-many (m2m) relationship in Django, you can use a nice filter-style multiple select widget to manage entries. However, Django only lets you edit the m2m relationship this way on the forward model. The only built-in method in Django to edit the reverse relationship in the admin is through an InlineModelAdmin.

	Below is an example of how to create a filtered multiple select for the reverse relationship, so that editing entries is as easy as in the forward direction.

	IMPORTANT: I have no idea for what exact versions of Django this will work for, is compatible with or was intended for.

	#!/usr/bin/env python

	"""
	Example Usage:
	$ ansible -i machine.py machinename -m ping
	"""


	import argparse
	import subprocess

	#!/bin/bash
	PROJECT_NAME=MyApp
	SCHEME_NAME=MyApp
	STARTTIME=$(date +%s);

	set -e
	set -x

	### Install dependencies
	echo "--- Install dependencies [Time Elapsed $(($(date +%s) - $STARTTIME))s]"

	// just include d3js and add animaDur in ms to marker's option

	L.SVG.prototype._setPath = function(layer,path){
	if(layer.options.animaDur)
	d3.select(layer._path).transition().duration(layer.options.animaDur).ease('linear').attr('d',path)
	else
	layer._path.setAttribute('d', path);
	}

	#!/bin/bash
	#
	# Script to setup a Elastic Beanstalk AMI with geospatial libraries and postGIS
	#
	# sh aws_ami_prep.sh > aws_ami_prep.log 2>&1 &

	# Go to ec2-user home directory
	cd /home/ec2-user

	# yum libraries

	import pyproj
	from shapely.geometry import shape
	from shapely.ops import transform

	geom = {'type': 'Polygon',
	'coordinates': [[[-122., 37.], [-125., 37.],
	[-125., 38.], [-122., 38.],
	[-122., 37.]]]}

	s = shape(geom)

	from functools import wraps
	from tornado.concurrent import return_future


	class CoroutineMaker(object):
	""" Convert a callback-based async function to a coroutine.

	The Tornado utility gen.Task is quite useful to convert callback-based
	async functions to coroutines, but has an important drawback: it expects
	the callback to be passed to the function in a keyword parameter

	upstream myapp {
	server 127.0.0.1:8081;
	}

	limit_req_zone $binary_remote_addr zone=login:10m rate=1r/s;

	server {
	listen 443 ssl spdy;
	server_name _;

Dexter Tad-y dexterbt1

Postgres Cheatsheet

Setup

installation, Ubuntu

PostgreSQL & PostGIS Cheatsheet

TOC