Daylite/ Simdex - Flight Data Storage with SQlite presented by Jonathan Cone - The S&T 2020
Topic: The presentation will discuss the architecture and development of daylite, a sqlite storage system and client for accessing FlightAware raw flight data
Summary: Daylite is a SQLite storage system, client, and miscellaneous tooling for FlightAware raw flight data. The service itself ingests various tab separated value (tsv) files and converts that data to SQLite databases. This is done both on an ad-hoc and online basis depending on the data stream. In the development of the service, the interaction with the SQLite api was tuned to achieve the desired performance and a rational for some of those decisions will be presented. A primary use case, which will be presented, is for providing the data for simulated flight engine decisions which this service and its use of SQLite handle well.
About the author:
As a Senior Software Engineer and manager of the Backend Crew, Jonathan Cone leads the team responsible for FlightAware’s primary customer-facing APIs and individual feed processors.