3 ms·
Here is a way to monitor these changes in real-time: https://play.clickhouse.com/play?user=play#U0VMRUNUIGNyZWF0ZWRfYXQsICdodHRwczovL2dpdGh1Yi5jb20vJ3x8cmVwb19u
by zX41ZdbW 2y ago
Here is a way to monitor these changes in real-time: https://play.clickhouse.com/play?user=play#U0VMRUNUIGNyZWF0ZWRfYXQsICdodHRwczovL2dpdGh1Yi5jb20vJ3x8cmVwb19uYW1lfHwnL2lzc3Vlcy8nfHxudW1iZXIgQVMgdXJsLCBldmVudF90eXBlLCBhY3Rvcl9sb2dpbiwgcmVwb19uYW1lLCB0aXRsZSBGUk9NIGdpdGh1Yl9ldmVudHMgV0hFUkUgbWF0Y2godGl0bGUsICdcXGJERUlcXGInKSBPUkRFUiBCWSBjcmVhdGVkX2F0IERFU0M= https://play.clickhouse.com/play?user=play#U0VMRUNUIGNyZWF0Z...
The SQL query:
SELECT created_at, 'https://github.com/'||repo_name||'/issues/'||number AS url, event_type, actor_login, repo_name, title FROM github_events WHERE match(title, '\\bDEI\\b') ORDER BY created_at DESC
- pdimitar 2y agoWait... HOW?!