Re:Ask HN: Storing spatial data in SQL
by Azuldolphin on Wednesday November 17, 2010 @11:24PM
(#1916862)
I'm hoping to use PostgreSQL (because I'm using Heroku;) ), but I read up on how MS Sql Server implements spatial indexes. Basically, it recursively divides the coordinate system into quadrants. Then, when looking for a range of coordinates, it can figure out which quadrants are covered by that range and efficiently query them using b-trees. Very cool. I wonder if PostgreSQL spatial support works similarly...
[ Parent
| on HN ]
Use PostGIS!
Heroku supports it -> http://www.mail-archive.com/[email protected]/msg04556...