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