Issue tables for open source projects

This repository is an attempt at making GitHub issue data in the 2i2c community more accessible and useful. It primarily does two things:

1. Publishes issue data. A GitHub workflow runs each day, scrapes the latest GitHub issues from the 2i2c-org organization, and publishes them into a public location.
2. Shows issue tables. A MyST website uses this data to display tables of issue metadata, sorted by sorted by community engagement (👍 and ❤️ reactions).

🔗 View the live site: https://2i2c-org.github.io/github-data/

🚨 This is not an official 2i2c service, it is just an experiment at making issue data more useful to the community.

How this works

Data collection and release workflow

1. GitHub Workflow (.github/workflows/release.yml): Runs periodically to download fresh issue data
2. Download Script (scripts/download_issues.py): Uses github-to-sqlite to fetch issues, PRs, and comments from the 2i2c-org organization
3. SQLite Database: Stores data in data/*.db files
4. GitHub Releases: Publishes database files as release assets for public access

Website with issue tables

1. Page Generator (scripts/generate_pages.py): Creates a page for each organization from a template
2. MyST Markdown Book: Pages have code cells that use the SQLite databases for subproject-specific issues, and render issue tables
3. GitHub Pages: Automatically builds and deploys the website on every push to main

Local development

Build and preview the book locally:

nox -s docs-live

Launch JupyterLab in the same environment used to build the book (for debugging):

nox -s lab

History

This repository was originally built by @choldgraf before being moved to the Jupyter org. This fork keeps the focus on 2i2c-org while staying close to the upstream repository.