Building Skygraph: A Google Flights-like App with Memgraph and Cypher

Skygraph, a Google Flights-like application, was developed using Memgraph and the Cypher query language to efficiently query European flight routes, aiming to simplify finding optimal flight options with a single query. The data model consists of City and Airport nodes connected by NEAREST_AIRPORT and FLIGHT_TO relationships, allowing comprehensive flight searches even for cities without airports. Data was imported into Memgraph using CSV files, and various Cypher queries were crafted to identify nearest airports, cheapest direct flights, cost-effective flights with layovers, and the shortest flights by duration. These queries demonstrate the application's ability to handle complex travel scenarios, offering flexibility and efficiency in flight searches. The project underscores Memgraph's capability to manage interconnected data, suggesting potential expansion to incorporate additional transportation modes for a more robust travel-planning tool.