I am running node-red on my RPi which gathers data from and Arduino and stores that data in an SQLite database via a Perl script. Works great! I thought I would give node-red a shot and managed to get a couple of gauges working, and a couple of text displays as well. Took a while, but that is fine.
What I Want..:
I am using both Dashboard and the SQLite modules. What I want to do is show some number (perhaps several hundred) of values on a line chart. So I run a query that goes something like:
select time_stamp, temp, temp_c from weather_data where time_stamp >= datetime('now', '-24 hour') order by time_stamp
All is well, the query runs fine and a rather large nested object is returned.
What I Don't Know:
I have searched for this on the web and, either I don't know enough to frame the question correctly, or there are not many folks that are doing this. I am very new to node-red also (about three days now), so I apologize if my question is covered somewhere. Any help appreciated...