aereodb

AereoDB is a simple, sql-based database for managing airports, airlines, flights and passengers.

Installation

run the docker-compose file to start the database

docker-compose up -d

enter the database container

mysql -u root -p -h 127.0.0.1

Note that the password matches the one in the docker-compose file

Debug:

To check if the db is initialized correctly, run the following command:

mysql -u root -p -h 127.0.0.1 < 01-init.sql 2> errors.log

Now this file should contain the errors if there are any.

Web interface

A web interface to dialog with the database realized in Next.js, that provides options to execute CRUD operations on the data.

Run

npm install
npm run dev