wviewweather.com

NorwegianWould · Joined: 07 Jan 2006 Posts: 23

Hi,

could we have some more records in the SQL archives? The ones that I am concerned about are cumulative ones like absolute values for rain-for-year, rain-for-month (rain so far then rain for each month as they go by), and even rain-for-day/week. I have not tried, have just started looking at it, but I think that computing these from the database will be too much prone to an accumulation of rounding errors (one reason why I do not like wunderground!).

Should they have their own table or should they go in the same 'archive' table as is used now?

Less important but useful for writing a generic query tool would be a table containing the units that each parameter is stored as.

Jeremy

mteel · Joined: 30 Jun 2005 Posts: 435 Location: Collinsville, TX

They should be calculated from the database, isn't that the point of a relational database? Store the base data then post-process it as you wish? That's at least the way I see it.

Rounding errors are software bugs in my opinion - any SQL database will keep many more decimal points of accuracy than these values require - BP and ET have 3 decimal places of resolution, the rest are 2 or less.

To date, there should be no confusion as the units are determined by the metric units setting in htmlgen.conf. Going forward it might be a good idea.

Mark

NorwegianWould · Joined: 07 Jan 2006 Posts: 23

Having looked at this in more detail, I agree that this is likely to work. There are not many dp required in the database as the rainfall values should always be an exact multiple of 0.2 mm or 0.01 in. I will try in due course...

Jeremy