What is the best way to store geodata (spatial data) for a small open source web application

I'm about to start developing a GIS web application.

I'll use PHP as language, Zend as Framework and Google Maps API for map rendering, but I didn't decided which back-end storage I'm going to use.

I'll need:

1. Store: Points (Lat & Lng) , Lines (Set of points), Polygons
开发者_运维百科
2. Make queries like:
   • "Which are the n Points of a given kind nearest of some other given Point ?"
   • "Which are the n Points of a given kind nearest of some given Line ?"
   • "Are point 'a' inside polygon 'g'?"
   • "What is the distance from point 'a' to point 'b' ?"
3. Combine these spatial data types with other relational data in the same table.

Which open source technology should I use?

If you're allowed to choose any storage - then you might prefer the ones, that support spatial indexes, like PostgreSQL (postgis) or MongoDB or mysql