Polish filtra and move data collection to Postresql
a project by jochenbreuer
Updated over 5 years ago. 2 hacker ♥️. 2 followers.

Last hackweek filtra was created – a tool to extract information like lead and cycle times from Github repos for (but not limited to) projects that are doing Kanban. The collected metrics can then be visualized with Grafana.

Currently there are two problems with filtra:

  1. There are two branches. The master branch, that can query information from one project per instance and the multi-board branch, that can query from multiple projects. Sadly the metrics looks a bit different for both of the branches and this needs to be fixed. Also unittests are badly needed! See: Metrics are different #20 and Missing Tests #23
  2. Currently filtra is basically a Prometheus endpoint. But Prometheus is not a perfect fit for this use-case, since we are only collecting a few metrics per day but with a very high retention. This is usually different for data collected with Prometheus. So the conclusion was that Postgresql would be a better fit for storing that data.

Join this project

Looking for hackers with the skills:

go golang github metrics graphql grafana postgresql leadtime cycletime projectmanagement

This project is part of:

Hack Week 19

Activity

  • over 5 years ago: PSuarezHernandez liked this project.
  • over 5 years ago: jcavalheiro liked this project.
  • over 5 years ago: jcavalheiro joined this project.
  • over 5 years ago: jochenbreuer started this project.
  • over 5 years ago: jochenbreuer added keyword "go" to this project.
  • over 5 years ago: jochenbreuer added keyword "golang" to this project.
  • over 5 years ago: jochenbreuer added keyword "github" to this project.
  • over 5 years ago: jochenbreuer added keyword "metrics" to this project.
  • over 5 years ago: jochenbreuer added keyword "graphql" to this project.
  • over 5 years ago: jochenbreuer added keyword "grafana" to this project.
  • over 5 years ago: jochenbreuer added keyword "postgresql" to this project.
  • over 5 years ago: jochenbreuer added keyword "leadtime" to this project.
  • over 5 years ago: jochenbreuer added keyword "cycletime" to this project.
  • over 5 years ago: jochenbreuer added keyword "projectmanagement" to this project.
  • over 5 years ago: jochenbreuer originated this project.


    • Comments

    • jochenbreuer
      over 5 years ago by jochenbreuer | Reply

      First update: We'll go with Sqlite instead of Postgresql.

    Similar Projects

    This project is one of its kind!