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


    • Comments

    • jochenbreuer
      over 2 years ago by jochenbreuer | Reply

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

    Similar Projects

    WASM support for cloud native buildpacks by atgracey

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

    grog by gbaccini

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

    A CLI for Harvester by mohamed.belgaied

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

    Create a CLI tool for interacting with Rancher Support Matrix by dpock

    Rancher Support Matrix CLI Helper

    A tool t...

    Create a CLI tool for interacting with Rancher Support Matrix by dpock

    Rancher Support Matrix CLI Helper

    A tool t...

    WASM support for cloud native buildpacks by atgracey

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

    Project Skyscraper - PoC of a Cloud Governance Dashboard by tmuntan1

    Project Description

    We would like to crea...

    grog by gbaccini

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

    A CLI for Harvester by mohamed.belgaied

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

    Generic retry command in openSUSE by okurz

    Motivation

    When automating tasks often the r...

    Tinker with mirror, a tool to watch and backup source code repositories by andreas-kupries

    Project Description

    Restart work on the `...

    Learn PostgreSQL advanced features by okurz

    Motivation

    The PostgreSQL database implement...

    Port the Minion job queue to TypeScript by kraih

    Project Description

    As part of the [mojo....