I plan to transition from MySQL to PostgreSQL on the Stractor project very soon. PostgreSQL is so difficult to pronounce that I've ignored it until now, but the capabilities of the PostGIS extension are too good to pass up.
The primary benefit of the PostGIS extension is that the geographic coordinate - a point on the globe - is a native data type. This means that queries based on the geometry of a sphere are readily supported, and you don't have to worry about stitching the boundary between 1° and 359° longitude, since PostGIS knows they are adjacent.
Leave a Reply