Location Intelligence: PostgreSQL

I’d always known that PostgreSQL had strong geospatial support, but nothing brought it home like the “Spatial Databases — An Enterprise Solution” panel here at the Location Intelligence conference. The panel was moderated by Oracle’s Spatial Guy, Jack Pellici, and all but one of the case studies used PostGIS (one of the developers of which I met today, Paul Ramsey). As bigwigs on stage pitch their wares and run through the checklist of things they support, “Postgres” is always something they say. It’s astonishing–not only how much mindshare PostgreSQL has in this field, but how much MySQL does not. I’ve not heard MySQL mentioned once, even though in the wider IT world it’s as fashionable as black.