Hi, I wanted to make a web app that uses stores some spacial data (simple latitudes and longitude pairs), preferably through django. All of the solutions on the web currently seem to involve some frameworks not supported by dreamhost (PostGIS, GEOS, etc.). Has anyone else dealt with this before and if so, did they find a preferable framework/platform to use?
If you only need to store latitude and longitude, why don’t store them on a simple table with a couple of float fields?
Even better, you can use some of MySQL spatial extensions:
Because that makes a number of really useful operations impossible to do efficiently, like “find all rows within one mile of this location”. MySQL’s spatial extensions do indeed solve this problem, though.