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

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


    • Comments

    • jochenbreuer
      almost 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...

    K3S Control Planes as a service by ademicev0

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

    Rancher Token Revoker by mbolot

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

    Vai: a Kubernetes API accelerator/cache by moio

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

    Real-time container runtime support by a_faerber

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

    Improve Docker registry listing tool by rbranco

    Project Description

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

    Elemental Operator: support hosts without TPM by fgiudici

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

    operator for s3gw by gbaccini

    Project Description

    Create a K8s CRD for ...

    Generic Wrangler Controllers by kjoiner

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

    Vai: a Kubernetes API accelerator/cache by moio

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

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

    Project Description

    Rancher Desktop is ...

    OSSelot collaboration on legal reviews of community packages by lkocman

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

    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...

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

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

    Humidity sensors with dashboard by joachimwerner

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

    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....