Infrastructure
Home SQL Server for Sensor Inputs
A Raspberry Pi-based MariaDB setup used to receive sensor data and support end-to-end experimental data collection without relying on hosted infrastructure.
MariaDBRaspberry PiApachePHPphpMyAdmin Raspberry PiMariaDBPHPSensor Data
Outcome: Created a small self-hosted database environment that could accept live sensor inputs and support downstream analysis projects.
Problem
Several sensor-based experiments depended on a database that could accept frequent incoming records from small devices without introducing unnecessary platform cost or complexity.
For that kind of prototyping work, using a lightweight self-hosted setup made more sense than outsourcing the entire data layer immediately.
Approach
I set up a Raspberry Pi-based server environment using Apache, PHP, and MariaDB.
- Database tables were created and managed through phpMyAdmin.
- Sensor devices posted data through PHP endpoints hosted on the Pi.
- The resulting records could then be queried for monitoring, modelling, and dashboard work.
This was less about enterprise-scale infrastructure and more about understanding the full chain from device input to stored data.
Why It Mattered
The value of this build was educational and practical at the same time.
It created a controlled environment for collecting live data while also forcing me to work through the interfaces between hardware, networked requests, server-side scripts, and database design. That foundation fed directly into later monitoring and analytics projects.