Diary.db: Difference between revisions
From Cumulus Wiki
Jump to navigationJump to search
mNo edit summary |
mNo edit summary |
||
Line 5: | Line 5: | ||
The weather diary is created specifically to record any snowfall, but as you can store a comment with any content, a number of Cumulus users are using it to record other entries that can be specific to a day (e.g. hailstorms), or indeed anything that might be recorded in a diary. | The weather diary is created specifically to record any snowfall, but as you can store a comment with any content, a number of Cumulus users are using it to record other entries that can be specific to a day (e.g. hailstorms), or indeed anything that might be recorded in a diary. | ||
=Format= | |||
The database uses SQLite format and a script to read this can be found in [[Weather Diary|Weather Diary article]]. | The database uses SQLite format and a script to read this can be found in [[Weather Diary|Weather Diary article]]. | ||
==Content== | |||
Each record has the following content: | Each record has the following content: | ||
* Date | * Date | ||
*Time ( | *Time | ||
** (In early releases, Mark set this to 00:00:00) | |||
**In later releases, this is set to 01:00:00, to minimise time zone issues. | |||
*Snow Falling (boolean) | *Snow Falling (boolean) | ||
*Snow Lying (boolean) | *Snow Lying (boolean) | ||
*Snow depth (unsigned decimal number) | *Snow depth (unsigned decimal number) | ||
*Entry (a text field for storing comments) | *Entry (a text field for storing comments) |
Revision as of 13:35, 4 April 2021
This is the file where MX stores its Weather Diary
Introduction
The weather diary is created specifically to record any snowfall, but as you can store a comment with any content, a number of Cumulus users are using it to record other entries that can be specific to a day (e.g. hailstorms), or indeed anything that might be recorded in a diary.
Format
The database uses SQLite format and a script to read this can be found in Weather Diary article.
Content
Each record has the following content:
- Date
- Time
- (In early releases, Mark set this to 00:00:00)
- In later releases, this is set to 01:00:00, to minimise time zone issues.
- Snow Falling (boolean)
- Snow Lying (boolean)
- Snow depth (unsigned decimal number)
- Entry (a text field for storing comments)