This app is a full-stack data tracking system with the backend running on Node-RED and hosted on DigitalOcean. It was made for the ITP Energy class to help everyone collect data on their solar IoT devices.
The backend listens to MQTT messages and stores them in an SQLite database. I wrote custom scripts to run SQLite commands in order to write and query the correct data in and out of the database.
The front end is a simple, plain Javascript app that fetches data by various filters and dynamically renders the components.
Skills I used
Network diagram
Node-RED flow diagram
While the main purpose of the system is to collect data for the entire class, part of its functions are modified specifically for our team’s project only. For example, it can transform specific data into audio files and serve the files to our Arduino. To read more about the solar energy and IoT part, you may visit:
