|PHP and MySQL to design map search site||#1|
I have a project to designing a website to search Zip codes on a digital map.
Somebody advised me to use PHP with postgreSQL or MySQL.
My professor wants me to tell him why I chose this for a mapping site.
The question is... Is there an expertise web language for GIS site ??
What is the difference if I use MySQL or MSsql or even Access if there is a connection to other remote database ??
posted date: 2008-12-21 13:44:00
|Re: PHP and MySQL to design map search site||#3|
It could be that I'm not entirely understanding your question, but:MySQL and PHP are fine choices, but the choice is pretty irrelevant as far as I know. You could do this in any language with any db. Whatever you're most comfortable with. Though I do know my friend who studied GIS did most of his projects in Python.I'm not positive what you're after, and I know University wants you to do things from scratch, but if I was doing this for a project it sounds like extending Google Maps could get you 99% of the way there?
posted date: 2008-12-21 13:50:00
|Re: PHP and MySQL to design map search site||#4|
Use language and db you are most comfortable 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, that way you are most productive, because any language or db is fine.
posted date: 2008-12-21 15:21:00
|Re: PHP and MySQL to design map search site||#5|
PHP and MySQL are highly available, usually free, have a less-steep learning curve than most and offer (like many languages) exactly what you need.I've done several mapping projects using google maps, location searches (based on LAT/LON or ZIP codes), interactive mappings and KML data. MySQL and PHP are more than capable.
posted date: 2008-12-21 15:33:00
|Re: PHP and MySQL to design map search site||#6|
As for LAT/LON support in the databases, Access is going to give you pretty much zip-zero in terms of spacial SELECT(s). PostgreSQL has more established support for this, but MySQL has played catch up in the last year or so and has a working method of this in the latest versions. MySQL's version is apparently marginally faster than PostgreSQL, but lacks some of the more advanced spatial features therefore it's pretty much limited to finding records that match a certain range of coordinates. I can't speak for Microsoft's SQL solution, but for huge amounts of data you are going to want to stick with PostgreSQL/MySQL for performance--unless you want to go with Oracle, but even then the performance difference would be negligible. M$ SQL is abysmal in regard to performance and Access will never scale. Ideally, you should evaluate what functions each database engine has for dealing with geo-spacial data and choose which one performs the best and has the best features given your application's requirements.
posted date: 2009-06-04 16:54:00
|Re: PHP and MySQL to design map search site||#7|
Thanks sir . You give me clear answer that help me .. Thanks again.
posted date: 2009-06-16 01:01:00
|Re: PHP and MySQL to design map search site||#8|
Not a problem. I love to help. You may also want to consider that the development of MySQL may come to an end in the near future. It's up in the air what will happen now that Sun acquired MySQL and Oracle subsequently acquired Sun. In addition, the primary MySQL developer and founder, Monty Widenius, has moved on to a new branch of the MySQL code and developing a new DB project. Postgres' source code is much better organized and I think stands a better chance of long-term support, but MariaDB (Monty's new project) could have staying power.
posted date: 2009-06-19 05:34:00
|Re: PHP and MySQL to design map search site||#9|
I attended a conference here in April where Monty spoke about this, so I thought it was important to note. :)
posted date: 2009-06-19 05:36:00
|select page: « 1 »|