pdehaan / repo-health-report

Issue tracker stats for repos.
https://repo-health-report.now.sh/
Mozilla Public License 2.0
3 stars 0 forks source link

Consume data from sql.telemetry #18

Closed pdehaan closed 4 years ago

pdehaan commented 4 years ago

@rpappalax sent me a telemetry dashboard URL, https://sql.telemetry.mozilla.org/queries/70708/source#177924.

Clicking the vertical meatball menu ("...") and then "Show API Key" gives you some CSV/JSON feeds you can use. Adding to the site is pretty trivial via an Eleventy shortcode, using something like:

{% sql_telemetry "70708" %}

Although now I'm wondering what the purpose of that number after the hash is. I think my scripts probably dropped it.

Another TODO here would be to see if we can wire this up into our URL caching layers. I think we're currently only doing that in the GitHub client layer to avoid hourly token limits, but it might be wise to cache telemetry results as well (either in same cache or separate from GitHub cache).

pdehaan commented 4 years ago

We currently have this in https://github.com/pdehaan/repo-health-report/blob/master/src/github/mozilla-mobile/fenix/index.njk

But, yeah, I'll file a separate issue for the caching issue since that's what I was specifically looking for.