1,655
edits
m (→Introduction) |
m (Protected "Cumulusmx.db": Edit warring ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]) |
||
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
[[Category:Cumulus MX]][[Category:Cumulus Files]] | [[Category:Cumulus MX]][[Category:Cumulus Files]] | ||
Line 19: | Line 9: | ||
'''Note''': The CumulusMX [[Weather Diary]] also uses a SQLite database stored in [[diary.db|data/diary.db]]. | '''Note''': The CumulusMX [[Weather Diary]] also uses a SQLite database stored in [[diary.db|data/diary.db]]. | ||
= | = The Recent History Data Table = | ||
The | |||
This table has the following columns: | This table has the following columns: | ||
Line 80: | Line 19: | ||
! style="width:280px" | Properties | ! style="width:280px" | Properties | ||
! style="width:450px" | Description | ! style="width:450px" | Description | ||
|- | |- | ||
| 0 | | 0 | ||
Line 87: | Line 25: | ||
| Primary Key, can never be NULL, No Default Value, | | Primary Key, can never be NULL, No Default Value, | ||
| Dates and times for the last 7 days, at whatever interval available (at logging interval for historic archive data, at one minute intervals while MX is running) | | Dates and times for the last 7 days, at whatever interval available (at logging interval for historic archive data, at one minute intervals while MX is running) | ||
|- | |- | ||
| 1 | | 1 | ||
Line 94: | Line 31: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The average wind speed (see [[Wind_measurement#Weather_Stations_and_Cumulus]] for links) calculated at the stated time, if necessary converted to units requested | | The average wind speed (see [[Wind_measurement#Weather_Stations_and_Cumulus]] for links) calculated at the stated time, if necessary converted to units requested | ||
|- | |- | ||
| 2 | | 2 | ||
Line 101: | Line 37: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The spot gust speed recorded at the stated time, if necessary converted to units requested | | The spot gust speed recorded at the stated time, if necessary converted to units requested | ||
|- | |- | ||
| 3 | | 3 | ||
Line 108: | Line 43: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The spot latest wind speed recorded at the stated time, if necessary converted to units requested | | The spot latest wind speed recorded at the stated time, if necessary converted to units requested | ||
|- | |- | ||
| 4 | | 4 | ||
Line 115: | Line 49: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The wind bearing (0 =calm), (1 to 360 = number of degrees) | | The wind bearing (0 =calm), (1 to 360 = number of degrees) | ||
|- | |- | ||
| 5 | | 5 | ||
Line 122: | Line 55: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The average wind bearing over the defined period | | The average wind bearing over the defined period | ||
|- | |- | ||
| 6 | | 6 | ||
Line 129: | Line 61: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The measured [[Temperature_(and_humidity)_measurement|outside air temperature]], if necessary converted to units requested | | The measured [[Temperature_(and_humidity)_measurement|outside air temperature]], if necessary converted to units requested | ||
|- | |- | ||
| 7 | | 7 | ||
Line 136: | Line 67: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The [[wind chill]], either calculated by MX, or supplied by weather station. (Note: strictly only valid for low temperatures and significant wind speeds) | | The [[wind chill]], either calculated by MX, or supplied by weather station. (Note: strictly only valid for low temperatures and significant wind speeds) | ||
|- | |- | ||
| 8 | | 8 | ||
Line 143: | Line 73: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The [[Temperature_(and_humidity)_measurement#Cumulus_Calculated_Parameters|dew point]], either calculated by MX, or supplied by weather station, for the stated time. | | The [[Temperature_(and_humidity)_measurement#Cumulus_Calculated_Parameters|dew point]], either calculated by MX, or supplied by weather station, for the stated time. | ||
|- | |- | ||
| 9 | | 9 | ||
Line 150: | Line 79: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The USA [[Heat index]] as calculated by Cumulus for the stated time (if the temperature is high enough) | | The USA [[Heat index]] as calculated by Cumulus for the stated time (if the temperature is high enough) | ||
|- | |- | ||
| 10 | | 10 | ||
| Humidity | | Humidity | ||
| float | | float | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The [[Temperature_(and_humidity)_measurement|Relative Humidity]] reported by the station at the stated time | | The [[Temperature_(and_humidity)_measurement|Relative Humidity]] reported by the station at the stated time | ||
|- | |- | ||
| 11 | | 11 | ||
Line 164: | Line 91: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The sea level pressure at the stated time, either as reported by the station or calculated by Cumulus from the absolute pressure reported by the station, if necessary converted to units requested | | The sea level pressure at the stated time, either as reported by the station or calculated by Cumulus from the absolute pressure reported by the station, if necessary converted to units requested | ||
|- | |- | ||
| 12 | | 12 | ||
Line 171: | Line 97: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The rainfall for today so far, calculated by Cumulus from the rain counter (column 15) now minus the rain counter at start of day, if necessary converted to units requested | | The rainfall for today so far, calculated by Cumulus from the rain counter (column 15) now minus the rain counter at start of day, if necessary converted to units requested | ||
|- | |- | ||
| 13 | | 13 | ||
Line 178: | Line 103: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| Solar radiation value reported by station at stated time | | Solar radiation value reported by station at stated time | ||
|- | |- | ||
| 14 | | 14 | ||
Line 185: | Line 109: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The Ultra Violet Index reported by station at stated time | | The Ultra Violet Index reported by station at stated time | ||
|- | |- | ||
| 15 | | 15 | ||
Line 192: | Line 115: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The rain counter is used by Cumulus for all rainfall outputs, this is its value at stated time | | The rain counter is used by Cumulus for all rainfall outputs, this is its value at stated time | ||
|- | |- | ||
| 16 | | 16 | ||
Line 199: | Line 121: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The [[Feels Like]] temperature calculated by MX at stated time | | The [[Feels Like]] temperature calculated by MX at stated time | ||
|- | |- | ||
| 17 | | 17 | ||
Line 206: | Line 127: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The Canadian [[Humidex|Humidity Index]], calculated by Cumulus at the stated time | | The Canadian [[Humidex|Humidity Index]], calculated by Cumulus at the stated time | ||
|- | |- | ||
| 18 | | 18 | ||
Line 213: | Line 133: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The [[Apparent temperature]], calculated by MX at the stated time | | The [[Apparent temperature]], calculated by MX at the stated time | ||
|- | |- | ||
| 19 | | 19 | ||
Line 220: | Line 139: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The indoor temperature directly as reported by station at stated time | | The indoor temperature directly as reported by station at stated time | ||
|- | |- | ||
| 20 | | 20 | ||
Line 227: | Line 145: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The indoor relative humidity directly as reported by station at stated time | | The indoor relative humidity directly as reported by station at stated time | ||
|- | |- | ||
| 21 | | 21 | ||
Line 234: | Line 151: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The calculated maximum value for solar radiation at stated time | | The calculated maximum value for solar radiation at stated time | ||
|- | |- | ||
| 22 | | 22 | ||
Line 241: | Line 157: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| Air Quality expressed in terms of particulate matter of 2.5 μm, or less, (?? Rolling 24 hours average ??) | | Air Quality expressed in terms of particulate matter of 2.5 μm, or less, (?? Rolling 24 hours average ??) | ||
|- | |- | ||
| 23 | | 23 | ||
Line 248: | Line 163: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| Air Quality expressed in terms of particulate matter of 10 μm, or less, (?? Rolling 24 hours average ??) | | Air Quality expressed in terms of particulate matter of 10 μm, or less, (?? Rolling 24 hours average ??) | ||
|- | |- | ||
| 24 | | 24 | ||
Line 255: | Line 169: | ||
| Not NULL, No Default Value | | Not NULL, No Default Value | ||
| The [[FAQ#How_is_my_rain_rate_calculated.3F|rainfall rate]] calculated for the stated time | | The [[FAQ#How_is_my_rain_rate_calculated.3F|rainfall rate]] calculated for the stated time | ||
|} | |} | ||
See [[Recent history|'''Recent history''' page]] | See [[Recent history|'''Recent history''' page]]. | ||
= SqlCache table = | |||
There is a MX setting ('''Settings''' | This table is fully managed by CumulusMX. You are not supposed to edit contents, you can view to quench your curiosity. | ||
There is a MX setting ('''Settings'''=>''MySQL settings''=>'''General Options'''=>tick Buffer commands on failure) that when enabled allows failed commands to be stored here. The buffer is lost when CumulusMX is restarted. | |||
This table holds a list of MySQL commands that are in the queue for '''[[MySqlConnect]]''' to run again. | This table holds a list of MySQL commands that are in the queue for '''[[MySqlConnect]]''' to run again. | ||
Line 279: | Line 194: | ||
* DivisionByZero (certain mathematical operations cannot be handled) | * DivisionByZero (certain mathematical operations cannot be handled) | ||
The table has two fields: | |||
{| border="1" class="wikitable" | |||
|- | |||
! style="width:10px" | Column number # | |||
" | ! style="width:80px" | Column name | ||
" | ! style="width:80px" | Column type | ||
! style="width:280px" | Properties | |||
! style="width:450px" | Description | |||
|- | |||
| 0 | |||
= | | key | ||
| integer | |||
| Primary Key, Not NULL, No Default Value, | |||
| An autoincrement integer for every SQL statement entered in the cache | |||
|- | |||
|- | |||
| 1 | |||
| statement | |||
| varchar | |||
| Not NULL, No Default Value, | |||
| Contains the actual SQL statement that failed | |||
|- | |||
|} | |||
= SQLite Sequence = | |||
No relevant information on this table is known |