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 (always 00:00:00)
*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)

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)