PHP and MySQL for developing a map search site
I have a project to build a website to find zip codes on a digital map. Someone advised me to use PHP with postgreSQL or MySQL.
My professor wants me to tell him why I chose this for a map site.
The question is, is there a web language of expertise for a GIS site? What's the difference if I'm using MySQL or MSsql, or even Access if there is a connection to another remote database?
thank
source to share
As far as LAT / LON support in databases is concerned, Access will provide you with almost zip-zero in terms of spatial SELECT (s). PostgreSQL has more specific support for this, but MySQL got it up and running in the last year or so and has a working method of doing this in recent versions. The MySQL version appears to be slightly faster than PostgreSQL, but lacks some of the more advanced spatial features, so it is largely limited to finding records that match a specific range of coordinates. I can't talk about a Microsoft SQL solution, but for huge amounts of data, you'll want to stick with PostgreSQL / MySQL for performance - if you don't want to go with Oracle, but even then the performance difference will be negligible. M $ SQL is terrible in terms of performance,and Access will never scale.
Ideally, you should evaluate what features each database engine has for working with geospatial data, and choose which one is best suited and has the best features based on your application requirements.
source to share
I may not fully understand your question, but:
MySQL and PHP are great choices, but the choices are pretty inappropriate as far as I know. You can do it in any language with any db. Anything you like the most. Although I know that a friend of mine who studied GIS did most of his projects in Python.
I'm not sure what you need and I know the University wants you to do something from scratch, but if I were doing it for a project, it looks like the Google Maps extension can help you 99%
source to share
Use the language and db you are most comfortable with with + Google Maps or Microsoft MapControl.
If you are asked why you chose these technologies, you can tell the truth - you are most comfortable working with them, thus you are most productive, because any language or db is fine.
source to share
PHP and MySQL are available, generally free, have a less steep learning curve than most, and offer (like many languages) exactly what you need.
I have done several mapping projects using google maps, location search (based on LAT / LON or zip codes), interactive mappings, and KML data. MySQL and PHP are more than capable.
source to share