Cumulusmx.db - Revision history

HansR: Protected "Cumulusmx.db": Edit warring ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

2022-11-02T10:14:38Z

Protected "Cumulusmx.db": Edit warring ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

← Older revision

Revision as of 10:14, 2 November 2022

2022-11-02T10:13:20Z

← Older revision		Revision as of 10:13, 2 November 2022
Line 1:		Line 1:
	This page is the new ''Cumulusmx.db'' page. This page and subpages hold a complete rewrite of the ''Webtags'' related pages.

	The information that was on this old ''Cumulusmx.db'' page has been moved to [[Cumulusmx.db_(preserving_history)\|Cumulusmx.db (preserving history)]]. You are advised to use that page until this page is ready and this message has been removed. If any questions or remarks please send a PM to [https://cumulus.hosiene.co.uk/memberlist.php?mode=viewprofile&u=9016 HansR] on the forum. Do not use the ''discussion'' tab unless accompanied by a PM: there is no automated signal to HansR if you use that page.

	This page and its subpages will document the Cumulusmx.db from the point of view of the CumulusMX software and not the Cumulus 1 legacy software. Cumulus 1 is no longer maintained and will eventually disappear. If you are still using it, please refer to the original [[Cumulusmx.db_(preserving_history)\|Cumulusmx.db (preserving history)]] page where @sfws has tried to give both packages equal value. That effort is no longer maintained in this ''Webtags'' page. We hope you will understand this approach.

	Please do not edit this page while it is being worked on i.e. while this message is still here.

	<hr/>

	[[Category:Cumulus MX]][[Category:Cumulus Files]]		[[Category:Cumulus MX]][[Category:Cumulus Files]]

2022-10-01T09:45:35Z

SqlCache table

← Older revision		Revision as of 09:45, 1 October 2022
Line 228:		Line 228:
	\|-		\|-
	\|}		\|}
	#key;
	#statement; A varchar (string) containing the SQL statement that failed

	= SQLite Sequence =		= SQLite Sequence =

2022-10-01T09:45:21Z

SqlCache table

← Older revision		Revision as of 09:45, 1 October 2022
Line 215:		Line 215:
	\|-		\|-
	\| 0		\| 0
			\| key
	\| Timestamp
			\| integer
	\| datetime
	\| Primary Key, ~~can never be~~ NULL, No Default Value,		\| Primary Key, Not NULL, No Default Value,
		⚫	\| An autoincrement integer for every SQL statement entered in the cache
	\| 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
			\| statement
			\| varchar
			\| Not NULL, No Default Value,
			\| Contains the actual SQL statement that failed
	\|-		\|-
	\|}		\|}
			#key;
⚫	~~#key;~~ An autoincrement integer for every SQL statement entered in the cache
	#statement; A varchar (string) containing the SQL statement that failed		#statement; A varchar (string) containing the SQL statement that failed

2022-10-01T09:42:16Z

SqlCache table

@@ Line 204: / Line 204: @@
 * DivisionByZero (certain mathematical operations cannot be handled)
-The table has two field:
+The table has two fields:
 #key; An autoincrement integer for every SQL statement entered in the cache
 #statement; A varchar (string) containing the SQL statement that failed

2022-10-01T09:41:05Z

SqlCache table

@@ Line 183: / Line 183: @@
 See [[Recent history|'''Recent history''' page]].
-=SqlCache table=
+= SqlCache table =
 This table holds a list of MySQL commands that are in the queue for '''[[MySqlConnect]]''' to run again.
@@ Line 202: / Line 204: @@
 * DivisionByZero (certain mathematical operations cannot be handled)

2022-10-01T09:31:55Z

The Recent History Data Table

← Older revision		Revision as of 09:31, 1 October 2022
Line 181:		Line 181:
	\|}		\|}

	See [[Recent history\|'''Recent history''' page]] ~~for more details~~.		See [[Recent history\|'''Recent history''' page]].

	=SqlCache table=		=SqlCache table=

2022-10-01T09:29:47Z

The Recent Data Table

2022-10-01T09:26:18Z

The Recent Data Table

← Older revision		Revision as of 09:26, 1 October 2022
Line 103:		Line 103:
	\| 10		\| 10
	\| Humidity		\| Humidity
	\| float ~~(1 decimal place)~~		\| 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

2022-10-01T09:24:35Z

Database Tables included

@@ Line 19: / Line 19: @@
 '''Note''': The CumulusMX [[Weather Diary]] also uses a SQLite database stored in [[diary.db|data/diary.db]].
 This table has the following columns:
@@ Line 260: / Line 209: @@
 See [[Recent history|'''Recent history''' page]] for more details.
-==SqlCache table==
+=SqlCache table=
 There is a MX setting ('''Settings''' -->> ''MySQL settings'' -->> '''General Options''' -->> Buffer commands on failure) that when enabled allows failed commands to be stored here.
@@ Line 288: / Line 237: @@
 The table contents are simple to explain, each time a new command is stored it is assigned a new number (that is automatically incremented from last number used) and the command itself is stored in a variable text length entry.
 CREATE TABLE sqlite_sequence (`name` TEXT, `seq` TEXT)