A database scheme for capturing sensor data

I’ve been monitoring a number of sensors in the house for a while now and storing the results in a simple database table. However the current structure isn’t very flexible. I have one table for electricity data, another for inside/outside temperature, humidity and light levels. Adding more sensors would mean adding more columns or new […]