Diary.db

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)