I'm building a small web application that needs to display scheduled flight information. I'm trying to understand the best way to work with external aviation data rather than maintaining airline schedules manually.
The application would need information such as flight numbers, departure and arrival airports, scheduled departure and arrival times, and airline details.
For developers who have worked with similar projects:
What API format do you normally use for this type of data?
Is it better to request schedule data on demand or cache it?
How do you handle changes or missing flight information?
Are there any common issues with timezone conversion when displaying departure and arrival times?
I'm particularly interested in practical approaches for integrating this into a PHP or JavaScript application.