This Steampipe dashboard explores how long issues remain open in a set of repos

This page summarizes the projects mentioned and recommended in the original post on /r/github
steampipe SQL Postgresql steampipe-plugin postgresql-fdw

InfluxDB
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors

  • steampipe-samples

    Examples, samples, snippets and scripts to use with Steampipe.

    • Repo: https://github.com/turbot/steampipe-samples/all/github-issue-duration

  • steampipe

    Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.

    • Steampipe is an open-source tool that translates APIs into Postgres tables, and visualizes that data on dashboards. One of its per-API plugins maps GitHub APIs to 41 tables. Two of those, github_my_repository and github_issue, are used in the SQL queries that drive this dashboard.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • steampipe-plugin-github

    Use SQL to instantly query repositories, users, gists and more from GitHub. Open source CLI. No DB required.

    • Steampipe is an open-source tool that translates APIs into Postgres tables, and visualizes that data on dashboards. One of its per-API plugins maps GitHub APIs to 41 tables. Two of those, github_my_repository and github_issue, are used in the SQL queries that drive this dashboard.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts