Polish filtra and move data collection to Postresql
a project by jochenbreuer
Updated over 3 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 3 years ago: PSuarezHernandez liked this project.
  • over 3 years ago: jcavalheiro liked this project.
  • over 3 years ago: jcavalheiro joined this project.
  • over 3 years ago: jochenbreuer started this project.
  • over 3 years ago: jochenbreuer added keyword "go" to this project.
  • over 3 years ago: jochenbreuer added keyword "golang" to this project.
  • over 3 years ago: jochenbreuer added keyword "github" to this project.
  • over 3 years ago: jochenbreuer added keyword "metrics" to this project.
  • over 3 years ago: jochenbreuer added keyword "graphql" to this project.
  • over 3 years ago: jochenbreuer added keyword "grafana" to this project.
  • over 3 years ago: jochenbreuer added keyword "postgresql" to this project.
  • over 3 years ago: jochenbreuer added keyword "leadtime" to this project.
  • over 3 years ago: jochenbreuer added keyword "cycletime" to this project.
  • over 3 years ago: jochenbreuer added keyword "projectmanagement" to this project.
  • over 3 years ago: jochenbreuer originated this project.


    • Comments

    • jochenbreuer
      over 3 years ago by jochenbreuer | Reply

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

    Similar Projects

    A CLI for Harvester by mohamed.belgaied

    [comment]: # Harvester does not officially come...

    Gameboy emulator written in Go by mikeletux

    [comment]: # (Please use the project descriptio...

    A CLI for Harvester by mohamed.belgaied

    [comment]: # Harvester does not officially come...

    Test Results for openQA on GitHub by livdywan

    Project Description

    Jobs in openQA are us...

    Create tool to analyze supportconfig to spot common SUSE Manager / Uyuni issues by cbosdonnat

    [comment]: # (Please use the project descriptio...

    Visualization of historical sar(1) archives by ggherdovich

    Project Description

    The sar(1) tool, fr...