I just posted the rather awkwardly-named Geo-Rails part 7: Geometry vs. Geography, or, How I Learned To Stop Worrying And Love Projections, the latest installment in my ongoing series on geospatial programming using Ruby and Rails. It is an opinionated look at the use of geometry vs. geography columns in PostGIS, and in general gives some guidelines on choosing a coordinate system for your spatial database.