We are the in the process of building out a web application that has a spatial data component. In the beginning our spatial data comparisons will take a given point and return matched overlapping spatial polygons.
That being said, our database has many other components that include all the typical things you would find in your general relational database.
We are at the point in our project where we must choose which database solution to use.
All project members are more familiar with the implementation and administration of MySQL, yet all research suggests that PostgreSQL is the better solution - especially in regards to spatial data using postGIS.
We expect (hope) our application will experience a lot of action with a lot of concurrent users.
Does anyone with experience using MySQL as their RDBMS with a spatial data component have any long term advice / experiences?
Are there any disadvantages of using PostGIS with the exception of familiarity?