Hacker News Reader

Is it possible that a rise in geospatial applications is partly a driver of Postgres’s rise in popularity? PostGIS seems to be the best option for storing geospatial data in an RDBMS (open source or otherwise).

View on HN

Anecdotal, but PostGIS is the reason I started using Postgres several years ago in some of my own projects, which later came in handy at different jobs. At one place, we standardized on Postgres partly because of PostGIS.

I think Django has had some influence too, since they've always recommended Postgres.

I selected PostgreSQL for a geo project recently. Still haven't got my head around tuning, but apart from that I've found it great to use. I use psycopg2 to connect from Python. No nasty surprises in use, and found that all my pidgin SQL translated easily. Also worth knowing that ogr2ogr supports PostgreSQL and is an awesome tool.

Reply on news.ycombinator.com