S
schworer
I have this idea for a web 2.0 site, but have very little web
development experience. I do have a ton of coding experience, so I'm
sure once I get the basic concepts down I should be golden.
Basically, my idea for the app is a google maps api mashup with another
online repository of data. I figure the best way to structure the site
is to cache the data form the online respository at regular intervals.
This avoids my site generating a ton of traffic to the repository.
I'm assuming caching the data in a SQL database (mysql or sqlserver) is
a good idea. The front end of the website will be AJAX
(GoogleMapsAPI), so do I need a database that can return query data in
xml?
What kind of mechanism does there need to be to get the sql backend to
update at a set timed interval (every 5 minutes)? Do I need to develop
some type of middleware to go out, parse the online repository, and
then update the database tables?
I'm looking for guidance from someone who has done this before.
Thanks in advance,
Andy
development experience. I do have a ton of coding experience, so I'm
sure once I get the basic concepts down I should be golden.
Basically, my idea for the app is a google maps api mashup with another
online repository of data. I figure the best way to structure the site
is to cache the data form the online respository at regular intervals.
This avoids my site generating a ton of traffic to the repository.
I'm assuming caching the data in a SQL database (mysql or sqlserver) is
a good idea. The front end of the website will be AJAX
(GoogleMapsAPI), so do I need a database that can return query data in
xml?
What kind of mechanism does there need to be to get the sql backend to
update at a set timed interval (every 5 minutes)? Do I need to develop
some type of middleware to go out, parse the online repository, and
then update the database tables?
I'm looking for guidance from someone who has done this before.
Thanks in advance,
Andy