Change owner of everything in PostgreSQL

There are a lot of tips out there for changing the owner of tables and sequences and views in PostgreSQL. This can often be needed when you are reworking a project or changing the structure of your database.

Create a URL shortener

URL shorteners are all the rage. At their core, they have two functions. First, encode an existing complete URL. Second, decode a shortened version of a URL and redirect to the (restored) URL.

PostGIS Odyssey Part 1

For a current (unreleased) project, I was starting to wander into the crazy world of maps. I started out with a very simple model of zip codes represented as points, but I had reached the limits of that approach being effective. I needed polygon data that gave a "truer" representation of what it means to be a zip code.