Project

General

Profile

Concept idea » History » Version 3

rainerkoenig, 2023-11-09 16:05

1 1 rainerkoenig
# Concept idea
2
3
After looking and trying both [Backlog Assistant](https://github.com/rakoenig/qe-yam-backlog-assistant) and [project management statistics](https://github.com/rakoenig/project_management_statistics) I think that the solution would be something that takes the best of both worlds.
4
5
## Backlog Assistant
6
### Pros
7
- Simple use of saved queries in Redmine
8
- New metrics are easy to create
9
- Direct links to the saved queries to review
10
- Runs on GitHub, no own VM necessary
11 3 rainerkoenig
12 1 rainerkoenig
### Cons
13
- Static HTML that looks like from 1995
14
- Just current data, history could only be found in the commits for gh-pages
15
16
## Project Management Statistics
17
### Pros
18
- With Grafana as a visualizer we have a modern look
19 3 rainerkoenig
20 1 rainerkoenig
### Cons
21
- Currently no job that freqently updates the interim SQLite Database
22
- Metrics extraction scripts are difficult to use if we want to emulate Redmine saved queries
23
- Needs some server or VM for automatic updates of the databases
24 3 rainerkoenig
- Main developer Ivan Lausch has left the company
25 1 rainerkoenig
26
## Idea 
27
28 2 rainerkoenig
Utilize Backlog Assistant to output to an Influx DB and than visualize that with Grafana. The yellow area in the diagram needs to be implemented.
29 1 rainerkoenig
30 2 rainerkoenig
![Metrics-concept.png](Metrics-concept.png)
31
32
Note: Backlog Assistand has already some code in it to suppoort InfluxDB format. This needs to be further investigated.