Skip to content

Instantly share code, notes, and snippets.

@loic-sharma
Created November 21, 2025 18:01
Show Gist options
  • Select an option

  • Save loic-sharma/2a0300658db09c045155cbb96ddbc29f to your computer and use it in GitHub Desktop.

Select an option

Save loic-sharma/2a0300658db09c045155cbb96ddbc29f to your computer and use it in GitHub Desktop.
Quantifying the demand to stop pinning the Flutter SDK's dependencies

Here is the activity on flutter/flutter#158050 in hte last 100 days (from 2025-08-13 to 2025-11-21):

Total reactions Total comments New reactions New comments
95 14 3 2

How to analyze this data yourself

  1. Install DuckDB.

  2. Download the data.

    git clone https://github.com/loic-sharma/github-insights.git
  3. Launch DuckDB.

    cd github-insights
    duckdb -ui
  4. Run this query:

    SELECT
      repository || '#' || id  AS issue_id,
      any_value(title) AS title,
      min(date) AS start,
      max(date) AS end,
      max(reactions) AS total_reactions,
      max(comments) AS total_comments,
      max(reactions) - min(reactions) AS new_reactions,
      max(comments) - min(comments) AS new_comments,
      'https://github.com/' || repository || '/issues/' || id AS issue_url,
    FROM 'top_issues/flutter/flutter/*.jsonl'
    WHERE
      date_diff('day', "date", today()) <= 100 AND
      issue_id = 'flutter/flutter#158050'
    GROUP BY repository, issue_id, id
    HAVING new_reactions > 0 OR new_comments > 0
    ORDER BY new_reactions DESC
    ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment