wviewweather.com Forum Index wviewweather.com
wview and Weather Topics
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

New archive records in SQL database?

 
Post new topic   Reply to topic    wviewweather.com Forum Index -> Wish List
View previous topic :: View next topic  
Author Message
NorwegianWould



Joined: 07 Jan 2006
Posts: 23

PostPosted: Mon Jan 23, 2006 3:47 am    Post subject: New archive records in SQL database? Reply with quote

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
Back to top
View user's profile Send private message
mteel



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

PostPosted: Mon Jan 23, 2006 9:49 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
NorwegianWould



Joined: 07 Jan 2006
Posts: 23

PostPosted: Thu Jan 26, 2006 8:28 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    wviewweather.com Forum Index -> Wish List All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group