Drone Project

Database project for school

Project Posted On: 10/30/24

Languages/Tools:
         

Drone hovering

This is a group project I am currently working on for my database course. The end goal is to create an “obstacle course”, and have users compete to get the lowest time and see if they can reach the leaderboard for the fastest completion.

The project is written in Python, and uses a MySQL database to store the user information and the leaderboard. The SQL database is hosted on a Docker container (using docker compose), and the front end to view the database is written in PHP.

The drones that are being used are Codrone EDU drones, that are programmed using Python.

Our first milestone for the project was testing the drone’s connection to the database and sensors, and practice SQL integration with Python and front end display with PHP.


Program Flow (Milestone 1)

First, the user will start the main program (we may containerize this in docker to make things easier for end users).

Starting Program

Starting the program

The user will then fly the drone, while the drone collects data.

Flying the drone

Flying the drone

Once the user has safely landed, the data collection will stop. The program will then send the data to the database, and the user can view the data using PHP.

Data sent to database Database Database Frontend


This is a project that I will be working on for the rest of the semester, and hopefully will get it to the point where it can be presented at symposium.