Ideas: visualize HPI data in a dashboard

[karlicoss]

For quantified self stuff some heavy manipulation with pandas is usually necessary (e.g. I'm doing this in my dashboard), so I doubt a general purpose web dashboard would cover it (unless it support JS snippets, which would be very helpful!). But it would be cool to have a quick way of overviewing/visualizing/aggregating data in the browser even if it's not perfect.

Quick googling results in:

• metabase: https://github.com/metabase/metabase#metabase
• redash: https://github.com/getredash/redash#readme

Both of them rely on some database (e.g. sqlite). While it's a bit inconvenient, probably good enough as the first order approximation. Since I'm extensively using NamedTuples/dataclasses, it's possible to adapt the data automatically without any boilerplate. In addition, cachew already dumps sqlite databases, which can be used as input data.

It would be also cool to have a native app (less hassle + better performance), but I'm not sure how to even start googling for that.

Related: https://github.com/KrauseFx/FxLifeSheet/issues/34 (I think we have similar goals!)

[karlicoss]

https://gridstudio.io/ looks promising

[karlicoss]

Started integrating with influxdb & Grafana, works pretty well for time series-like stuff

https://github.com/karlicoss/HPI/blob/6d9bc2964b24cfe6187945f4634940673dfe9c27/my/bluemaestro.py#L194-L220

https://twitter.com/karlicoss/status/1361100437332590593

https://github.com/karlicoss/HPI/blob/6239879245eca9c87e7a1e7e4da3382f34782464/my/rescuetime.py#L85-L109

https://twitter.com/karlicoss/status/1360369025122000898