Flights

⚠️⚠️⚠️

[UNMAINTAINED]
This repository has been split up (by back-end language), moved and is currently maintained at the following locations:

• Node.js (basic)
• Python (basic)

⚠️⚠️⚠️

Flights is a web application, backed by the power of the MariaDB Connectors and MariaDB ColumnStore database, allows you to analyze millions flight records from the United States Department of Transportation in real time without needing to add any indexes!

This README will walk you through the steps for getting the Flights web application up and running using MariaDB ColumnStore. To ensure success, please follow the instructions in order.

Note: The code provided within this repository is completely open source. Please feel free to use it as you see fit.

Table of Contents

1. Requirements
2. Getting started with MariaDB
3. Getting started with the app
   1. Get the code
   2. Get the data, create the schema, and load the data
   3. Anatomy of the app
   4. Build and run the app
4. Support and contribution
5. License

Requirements

This sample application, no matter which API project you target, will requires the following to be installed/enabled on your machine:

• MariaDB Client, used to connect to MariaDB instances.
• Bash (if you are using Windows 10, you will need to enable the Windows Subsystem for Linux), used to run the data download script

Getting started with MariaDB

MariaDB is a community-developed, commercially supported relational database management system, and the database you'll be using for this application.

If you don't have a MariaDB database up and running you can find more information on how to download, install and start using a MariaDB database in the MariaDB Quickstart Guide.

Getting started with the app

In order to run the Flights application you will need to have a MariaDB instance to connect to. For more information please check out "Get Started with MariaDB".

Get the code

Download this code directly or use git (through CLI or a client) to retrieve the code using git clone:

$ git clone https://github.com/mariadb-corporation/dev-example-flights.git

Get the data, create the schema, and load the data

This application uses (US domestic) flight data freely available from the Bureau of Transportation on time performance dataset. The [get_flight_data.sh] shell script will be used to download the flight data (between 1990 and 2020) into a folder called data.

Complete the following steps.

1. Download the flight data (approx. 180 million records, ~30 GB). Depending on your internet connection this may take some time. However, you can simply modify get_flight_data.sh script to adjust the amount of flight information that is downloaded. Doing so will not disrupt subsequent steps.

$ ./get_flight_data.sh

2. Create the flights database, airlines/airports/flights tables, and load the tables with data. Be sure to include your database instance specific information (host url, port number, username, and password)

$ ./create_and_load.sh host_url port user password

Note: Remember to wrap argument values in single quotes if they contain special characters (e.g. !)

By default the create_and_load.sh script has ssl enabled and assumes a MariaDB SkySQL certificate authority chain file exists next to it. Feel free to modify accordingly.

Anatomy of the app

This application is made of two parts:

• Client
  • communicates with the API.
  • is a React.js project located in the client folder.
• API
  • uses a MariaDB Connector to connect to MariaDB.
  • contains multiple projects, located in the api folder.
    • Node.js
    • Python

See the README's in client and api for more information on how to get started!

Build and run the app

1. Navigate to the client folder and execute the following CLI command to install the package dependencies for the React.js application.

$ npm install

2. Pick an API project and follow the instructions of the README to build and run the API project.

3. Navigate to the client folder and execute the following CLI command to start the React.js application.

$ npm start

4. Open a browser window and navigate to http://localhost:3000.

Support and Contribution

Please feel free to submit PR's, issues or requests to this project project or projects within the official MariaDB Corporation GitHub organization.

If you have any other questions, comments, or looking for more information on MariaDB please check out:

• MariaDB Developer Hub
• MariaDB Community Slack

Or reach out to us diretly via:

• developers@mariadb.com
• MariaDB Twitter

License