nabucosound

Upgrade PostgreSQL

After a "brew upgrade", I had to solve the incompatible data format between versions.

Command history

cd /usr/local/var/postgres/ cat PG_VERSION

nabucosound

# Custom propmt
export PS1="\u:\w$ "

# ls with colors
export CLICOLOR=1
export LSCOLORS=gxgxcxdxbxegedabagacad

# Homebrew binaries and scripts before system ones
export PATH=/usr/local/bin:/usr/local/sbin:/usr/local/opt/ruby/bin:$PATH

nabucosound

" Pathogen load
filetype off
call pathogen#infect()
call pathogen#helptags()

filetype plugin on

" No Vi Compatibility
set nocompatible

nabucosound

#!/bin/bash
#
# Install Postgres 9.1, PostGIS 2.0 and pgRouting on a clean Ubuntu 12.04 install (64 bit)
# updated to PostGIS 2.0.1

# add the ubuntu gis ppa
sudo apt-get -y install python-software-properties
sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable 
sudo apt-get update 

nabucosound

PostgreSQL 9.1 Cheatsheet

sudo su postgres

Create cluster:

pg_createcluster 9.1 main --start

nabucosound

Amazon AWS Cheatsheet

Made by Nabuco (http://nomadblue.com/).

Note: Substitute [params] with the proper values.

Put dump file into S3 bucket using cmd from Boto (pip install boto):

nabucosound

Writing to a Nomadblog post

Steps

1. Copy the template.rst into a new source reStructuredText file:

   cp template.rst src.rst

nabucosound

Python packages on PyPi, Github and ReadTheDocs

I always forgot to get packaging done right on the first try. It is a task that we don't do every day, so I created this how-to gist. It helps out creating packages hosted on GitHUb, listed on PyPi and its documentation hosted on ReadTheDocs.

Package scaffolding

nabucosound

Command Line Cheatsheet

Filesystem

Delete recursively:

find . -name "*.pyc" | xargs rm -f

nabucosound

MySQL

Install MySQL in Mac OS X with Brew

# Install brew install mysql