Diary.db: Difference between revisions

From Cumulus Wiki
Jump to navigationJump to search
(Created page with "'''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 wit...")
 
Line 13: Line 13:
*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 19:08, 31 May 2020

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.

The database uses SQLite format and a script to read this can be found in Weather Diary article.

Each record has the following content:

  • Date
  • Time (always 00:00:00)
  • Snow Falling (boolean)
  • Snow Lying (boolean)
  • Snow depth (unsigned decimal number)
  • Entry (a text field for storing comments)