Enhancement: Create interface for viewing historical graphs of system status overtime.

[ethanwillis]

The touch controls are nice. However it would be great to have an extra frontend component that shows graphs for the historical data recorded by the system.

[ljyanesm]

Regarding this issue, I was thinking of using grafana, maybe we can change the backend database to influxdb which behaves similarly but has better plug in support on the grafana side.

Given that there are other issues referring to bundling it all up in docker containers, it seems like a sensible migration to do.

[ethanwillis]

I haven't used influxdb before, but I'll take a look into that.

I'm familiar with Grafana from my dayjob. I'll make a branch and test out integrating it. I'll post some screenshots and thoughts when that's done so we can decide if that's the way we want to go.

[ethanwillis]

Regarding docker support, there's a basic version of that already completed in the PR I sent over if you want to give it a spin. You can also just clone my fork and check it out. I put a README in each subproject(backend, gui) and updated the main README with how to start up each service as a single container or as a full docker-compose system.

[ethanwillis]

@ljyanesm

https://github.com/CommonGarden/Grow-IoT/blob/development/docker-compose.yml

I happened upon a grafana + meteor + influxdb dashboard with an example docker setup. This whole repository could be a great source of inspiration.

[ljyanesm]

@ethanwillis
I've started working on the influxdb migration, feel free to include/adapt some of your previous commits to use influxdb. I will be including an id for each "device" to easily manage different chambers.

The idea is to use influxdb afterwards as the grafana backend, I was thinking about including some of the graphs on the frontend gui as a "tab" or something similar to provide easy access to historical data from the interface.

Thanks for any comments or commits in this direction.

[ljyanesm]

@ethanwillis
We have a new branch that works with mysql and a grafana interface can be configured against the mysql backend easily. If we have progress on #15 it would make it much easier to test and develop without the arduino. I'll be paying a bit more attention to this issue and #15 the next couple of days.