I am in the process of creating a consumer facing location based mobile app that will heavily need GIS support. I have narrowed down the databases to Postgres (PostGIS) and mongodb.
I was wondering how someone who has experience with both would rate the geospatial support particularly in the area of:
- Performance
- Query expressibility
- Precision
Please discuss pro and cons, gotchas and limitations.