Full-stackCompleted
Gamma Air
Airline-ops database platform
Full-stack · Interactive previewGamma AirAirline-ops database platform
Walkthrough video demo (Appsmith UI over a Flask + MySQL API).
Open live app ↗Gamma Air models an airline-operations marketplace: airlines list flights they need filled, qualified pilots are assigned, and customers book tickets, while customer representatives manage both sides. A normalized 14-table MySQL schema (airlines, airports, planes/seats, flights, tickets, reviews, pilot schedule requests, and a self-managing customer-rep hierarchy) sits behind a Flask + Flask-RESTful API exposed as four role-scoped blueprints (login, customers, reps, pilots), with an Appsmith low-code frontend. The two-service stack (Flask + MySQL 8) runs via Docker Compose. Built as a database-design course project.
- Python
- Flask
- Flask-RESTful
- MySQL
- SQL
- Docker
- Appsmith
- Schema
- 14 tables
- API
- Flask REST · 4 blueprints
- Roles
- Pilots · customers · reps
- Stack
- Flask · MySQL · Docker