Domoticz Database
2 August, 2018
15:48
Aa
The databse pictures below are made with SQLiteStudio. I wouldn't advise SQLiteStudio because it's terribly slow.
A better DB viewer is DBBrowser.
Sensor Values
Daily Database
Description | Example |
Find the ID in the table DeviceStatus, so for the CO2-sensor the ID = 23 |
|
So for the CO2-sensor we find DeviceRowID =23 and on the right you can see that the CO2-Sesnor is sampled with a 5 minute interval.
|
|
But this doesn't work for multi-parameter sensors, like the BPE280, which measures Temperature, Barometric Pressure and Relative Humidity.
Partially it does, Temperature can be found for all sensors, Some still have to be found. |
|
Some tables store specific 5 minutes data: Rain Temperature (a lot parameters) UV Wind |
|
The bijbehorende calendar table contains 6 hour? Samples
Or does it not a large change of the value ? |
Screen clipping taken: 02-Aug-18, 16:08
|
Created with Microsoft Office OneNote 2007
One place for all your notes and information