Scripting grafana dashboards

[jennydaman]

Create some interesting visualizations of ChRIS data e.g.

Figure out how to automatically add these dashboards to Grafana when the project is brought up by docker compose up -d (or as a docker compose run command fired by ./minichris.sh

[sakshi1215]

Can you assign this to me @jennydaman ?

[ifykendu]

please i want to work on this project

[kibablu]

@sakshi1215 were you able to get grafana up and running?

[sakshi1215]

@sakshi1215 were you able to get grafana up and running?

Yes, it was working well for me

[MdSahil-oss]

@jennydaman I would like to work on it. Can you assign it to me ?

[jennydaman]

Sure. Some work in a related issue was done in #15, this could be helpful.

[MdSahil-oss]

@jennydaman Can you give me a brief summary of all chris's data you want to be visualized by grafana ?

[jennydaman]

@MdSahil-oss some examples of useful visualizations would be as in the above screenshot:

• most popular plugins of all time
• plugin instances created per week, showing what state they're in (e.g. finishedSuccessfully, finishedWithError, cancelled)...

Imagination is the limit when it comes to what visualizations could be useful but I think having these two default visualizations will be good. Later we'll also want to add visualizations from cAdvisor+prometheus

[MdSahil-oss]

@jennydaman can you tell in which table of chris_db dock_image column exist, I tried to find it, but failed.

[jennydaman]

SELECT dock_image FROM plugins_plugin;

Join example:

SELECT plugins_plugin.id, plugins_pluginmeta.name, plugins_plugin.dock_image
FROM plugins_plugin
INNER JOIN plugins_pluginmeta ON plugins_plugin.meta_id = plugins_pluginmeta.id;

The relationship between pluginmeta --> plugin is [1, N)