On Saturday, January 23, 2016 at 4:41:51 PM UTC-5, Steve Harris wrote:
Thank you so much for the advice, I've now got it working :)
Check out
http://www.raynesparkweather.co.uk/sw20wxAnd also
http://www.raynesparkweather.co.uk/weewxOne final question if I may,
I'd like to be able to have daily graphs shown on the website, by selecting say a particular date. I'm sure the data is archived in the SQL DB as I see data going back week or so at 5 minute intervals.
What query would I need to run in the skin config to get that to happen?
THanks for a great piece of code !:)
nice work steve!
would you consider writing up what you did then making a link to it on the weewx wiki? or just put it on the weewx wiki at github?
the weewx report engine is not set up to do on-the-fly queries such as "select an arbitrary date then show the data for that day". you would have to write some javascript or php to query the database then display the results.
or, if you know what queries you'll want (e.g., daily graphs for each of the past 14 days), you could create a skin with canned queries.
tom is working on weert, which provides a RESTful api that will make dynamic plots and interactive queries *much* easier to implement. its a bit like graphite or influxdb, but simple and flexible (for example, no rigid schemas). fyi, some of the other tools for doing this include influxdb, redis, rrdtool, graphite, with some focused on timeseries and others not so much. on top of those you have the display layer such as D3, highcharts, jcharts, and others.
weewx will still do the data collection, uploading, and optionally the static reports. weert will provide the back-end for interactive plots, visualizations, and queries.
m