Can anyone suggest me which database to be used with OpenLayers? I have to store the values in a database table and retrieve them (trivial tasks). Which is better MySQL or PostGIS? Can anybody give benefits of these?
Answer
The bostongis comparison is not a really up-to-date document but it can be a good start, at least to see which aspects is a priority to you, and what you should consider as mandatory or optional to make your choices. The comparison is generic, not related to openlayers.
For your OL project, I guess you should also consider the DB availability from your hosting unless you have no constraint regarding this point.
From Postgis, you can natively export a query result as kml and json (and easily read it with OL), which is I think impossible with MySQL (you'll have a third party call to dynamically create it through any language..)
No comments:
Post a Comment