Queries used in article Popularity of frontend frameworks in GitHub repositories
- package-json-files
- date-of-modification
- package-json-files-with-date
- package-json-dependencies
- frameworks-in-dependencies
{"traceEvents":[{"pid":37053,"tid":15363,"ts":29055802932,"ph":"X","cat":"toplevel","name":"MessagePumpLibevent::OnLibeventNotification","args":{"src_file":"../../mojo/edk/system/channel_posix.cc","src_func":"StartOnIOThread"},"dur":196,"tdur":86,"tts":3786}, | |
{"pid":37053,"tid":15363,"ts":29055803176,"ph":"X","cat":"toplevel","name":"MessagePumpLibevent::OnLibeventNotification","args":{"src_file":"../../mojo/edk/system/channel_posix.cc","src_func":"StartOnIOThread"},"dur":39,"tdur":36,"tts":3888}, | |
{"pid":37053,"tid":15363,"ts":29056719406,"ph":"X","cat":"toplevel","name":"MessagePumpLibevent::OnLibeventNotification","args":{"src_file":"../../mojo/edk/system/channel_posix.cc","src_func":"StartOnIOThread"},"dur":55,"tdur":52,"tts":3948}, | |
{"pid":37053,"tid":775,"ts":29055803102,"ph":"X","cat":"toplevel","name":"TaskQueueManager::ProcessTaskFromWorkQueue","args":{"src_file":"../../base/trace_event/trace_log.cc","src_func":"SetEnabled"},"dur":28,"tdur":27,"tts":60182}, | |
{"pid":37053,"tid":775,"ts":29055803136,"ph": |
SELECT dev.taskType as taskType, dev.percent as dev, start.percent as start, dev.type as type | |
FROM ( | |
SELECT scripts.taskType as taskType, scripts.percent as percent, types.group as type | |
FROM ( | |
SELECT taskType, (count(distinct projectID) / 15868 * 100) as percent | |
FROM | |
(SELECT *, 'nodemon' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bnodemon\b)')), | |
(SELECT *, 'pm2' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bpm2\b)')), | |
(SELECT *, 'istanbul' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bistanbul\b)')), | |
(SELECT *, 'jsdoc' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bjsdoc\b)')), |
SELECT build.taskType as taskType, build.percent as build, start.percent as start, build.type as type | |
FROM ( | |
SELECT scripts.taskType as taskType, scripts.percent as percent, types.group as type | |
FROM ( | |
SELECT taskType, (count(distinct projectID) / 65794 * 100) as percent | |
FROM | |
(SELECT *, 'nodemon' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bnodemon\b)')), | |
(SELECT *, 'pm2' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bpm2\b)')), | |
(SELECT *, 'istanbul' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bistanbul\b)')), | |
(SELECT *, 'jsdoc' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bjsdoc\b)')), |
SELECT scripts.taskType as taskType, scripts.percent as percent, types.group as type | |
FROM ( | |
SELECT taskType, (count(distinct projectID) / 65794 * 100) as percent | |
FROM | |
(SELECT *, 'nodemon' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bnodemon\b)')), | |
(SELECT *, 'pm2' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bpm2\b)')), | |
(SELECT *, 'istanbul' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bistanbul\b)')), | |
(SELECT *, 'jsdoc' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bjsdoc\b)')), | |
(SELECT *, 'documentation' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bdocumentation\b)')), | |
(SELECT *, 'make' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bmake\b)')), |
SELECT task, (count(distinct projectID) / 65794 * 100) as percent | |
FROM [scripts] | |
WHERE taskName = 'build' | |
GROUP BY task | |
ORDER BY percent DESC |
SELECT scripts.taskType as taskType, scripts.percent as percent, types.group as type | |
FROM ( | |
SELECT taskType, (count(distinct projectID) / 107646 * 100) as percent | |
FROM | |
(SELECT *, 'nodemon' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bnodemon\b)')), | |
(SELECT *, 'pm2' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bpm2\b)')), | |
(SELECT *, 'istanbul' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bistanbul\b)')), | |
(SELECT *, 'jsdoc' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bjsdoc\b)')), | |
(SELECT *, 'documentation' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bdocumentation\b)')), | |
(SELECT *, 'make' as taskType FROM [scripts] where REGEXP_MATCH(task, r'(\bmake\b)')), |
SELECT task, (count(distinct projectID) / 107646 * 100) as percent | |
FROM [scripts] | |
WHERE taskName = 'start' | |
GROUP BY task | |
ORDER BY percent DESC |
SELECT task, (count(distinct projectID) / 202808 * 100) as percent | |
FROM [scripts] | |
WHERE taskName = 'test' | |
GROUP BY task | |
ORDER BY percent DESC |