(by @andrestaltz)
If you prefer to watch video tutorials with live-coding, then check out this series I recorded with the same contents as in this article: Egghead.io - Introduction to Reactive Programming.
Colin Weinshenker caweinshenker
alysonla
/ active-issues.sql
Last active
September 19, 2023 11:21
Queries that power the open source section of the 2016 Octoverse report https://octoverse.github.com/2016/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Active issues | |
| -- Count of total active issues in the specified time frame | |
| -- Source: githubarchive public data set via Google BigQuery http://githubarchive.org/ | |
| SELECT | |
| COUNT(DISTINCT JSON_EXTRACT_SCALAR(events.payload, '$.issue.id')) AS events_issue_count | |
| FROM (SELECT * FROM TABLE_DATE_RANGE([githubarchive:day.],TIMESTAMP('2015-09-01'),TIMESTAMP('2016-08-31'))) | |
| AS events | |
| -- 10,723,492 active issues |
staltz
/ introrx.md
Last active
May 3, 2026 02:38
The introduction to Reactive Programming you've been missing