Home SQL Server for Sensor Inputs

A Raspberry Pi server I built with Apache, PHP, and MariaDB to collect sensor readings for analysis.

MariaDBRaspberry PiApachePHPphpMyAdminRaspberry PiMariaDBPHPSensor Data

Outcome: Set up a self-hosted database that received sensor readings and made them available for analysis.

Original phpMyAdmin view of the local sensor database
Original phpMyAdmin view of the local sensor database
On this page

Task

My sensor experiments needed a database that could receive frequent device readings without hosted infrastructure.

Build

I set up Apache, PHP, and MariaDB on a Raspberry Pi. Devices posted readings to PHP endpoints, while phpMyAdmin was used to create and manage the database tables.

Result

The stored records could be queried for monitoring, modelling, and dashboards. Building the server helped me work through the interfaces between device requests, server-side scripts, and database storage.

AI assistant · Site sources

Guide to Vairavan

Reading Home

Explore the work. Get to know Vairavan.

Ask about Vairavan’s research, technical projects, background, media appearances or speaking engagements.

AI answers can be mistaken. Check the linked sources.