KML, PERL, MYSQL - Are these the right technologies for the server of my MapKit App ?

[Pfistou]

Hi Everyone !

I am about to start developing an application that uses MapKit and annotations and I wonder which technologies to use at the server side.

After a week of reading on the net, I figured out that I could:

- use Google Earth to produce my content (placemarks) and save it as a kml file,
- parse the file in perl and load the data in mysql on my server thanks to a perl script,
- whenever a region is displayed on the iphone, issue a php request to my server. At the server, execute a perl script to select the needed data in mysql database and convert it into a XML(KML) file,
- download the file and parse it in my iphone app in order to retrieve the placemark,
- create annotations from the placemark retrieved

Before going further in the study of those technologies (php, perl, mysql, xml) can anyone tell me I am right or if there is a simpler way.

Thanks for all advices on this subjects (I am a beginner as you can see) and maybe usefull links that could help me.

Yours,
Pfistou

[oooJamesooo]

Do you have any links to where you even put this together from? I am trying something very similar.