Polish filtra and move data collection to Postresql
a project by jochenbreuer
Updated about 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

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


    • Comments

    • jochenbreuer
      about 3 years ago by jochenbreuer | Reply

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

    Similar Projects

    Vai: a Kubernetes API accelerator/cache by moio

    ![Kubernetes API caching layer according to Sta...

    A CLI for Harvester by mohamed.belgaied

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

    Real-time container runtime support by a_faerber

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

    Rancher Token Revoker by mbolot

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

    K3S Control Planes as a service by ademicev0

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

    Improve Docker registry listing tool by rbranco

    Project Description

    [regview](https://git...

    Vai: a Kubernetes API accelerator/cache by moio

    ![Kubernetes API caching layer according to Sta...

    A CLI for Harvester by mohamed.belgaied

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

    Generic Wrangler Controllers by kjoiner

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

    Elemental Operator: support hosts without TPM by fgiudici

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

    Expanding e2e tests on Windows self-hosted runners via CI by iguimaraes

    Achievements:

    • Documented all necessary s...

    obs_scm_demo by smithfarm

    Project Description

    For a long time, I ha...

    OSSelot collaboration on legal reviews of community packages by lkocman

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

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

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

    Humidity sensors with dashboard by joachimwerner

    Build a network of ("edge") humidity sensors...

    OpenQA test list views improvement by mdati

    Project Description

    Create views of **Ope...

    Visualization of historical sar(1) archives by ggherdovich

    Project Description

    The sar(1) tool, fr...

    Port the Minion job queue to TypeScript by kraih

    Project Description

    As part of the [mojo....

    Learn PostgreSQL advanced features by okurz

    Motivation

    The PostgreSQL database implement...