I’ve been busy so I haven’t had as much time to devote to the weather stations. One thing I did kill a lot of time this weekend was the new charts. On the chart in the last post, the sample script was pulling all day from today (the day the script was run) which means if you checked it at 9am you would get 9 hours of data, if you checked it at 9pm you would get 21 hours of data. This seemed silly, so I tried and tried to get sqlite to give me 24 hours worth of data to no avail. Then I figured out this is why real applications don’t use sqlite, and real databases have built-in functions for this stuff. On top of this, wview has an export utility to dump the sqlite data into a MySQL database, so that’s what I did. Now I need to find out how to do MySQL queries since it is very different from sqlite, including having to deal with permissions and multiple databases. It also allows for much more like building it directly into a website and building quires on demand.
Much more learning ahead!