Data Management
SQLite was chosen as our database management system due to its simple implementation and serverless nature. Because SQLite is file-based, it is suitable for the needs of this project and is easy to share with the group for testing. It is easy to populate with sample data via a Python program to test our network communication. SQLite was used with Chart.js on the Flask Front End to display threat data from the database in real time in an intuitive manner.
Sample Sensor Data Table
Sample Threats Table
Data Visualization/Front End
A web app for visualization of sensor data and threat level/analysis was created with Python and Flask. The app retrieves data from the SQLite database tables and displays it to the user. Further visualization is evident in a live-updating graph of the threat level and a statement relaying the current threat level to the user. The graphing is using the Chart JS Library. Further security of the web app includes user login and hashing/salting of passwords.