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
Michał Janaszek Everettss
Everettss
/ popularity-of-frontend-frameworks-in-github.md
Last active
December 19, 2018 05:31
Everettss
/ state-of-npm-scripts.md
Last active
March 5, 2019 05:59
Everettss
/ trace.json
Created
November 10, 2017 13:57
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
| {"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": |
Everettss
/ dev-vs-start.sql
Created
September 28, 2017 14:34
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
| 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)')), |
Everettss
/ start-vs-build.sql
Created
September 28, 2017 14:11
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
| 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)')), |
Everettss
/ technologies-build.sql
Last active
September 25, 2017 19:36
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
| 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)')), |
Everettss
/ build-tasks.sql
Created
September 18, 2017 15:04
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
| SELECT task, (count(distinct projectID) / 65794 * 100) as percent | |
| FROM [scripts] | |
| WHERE taskName = 'build' | |
| GROUP BY task | |
| ORDER BY percent DESC |
Everettss
/ technologies-start.sql
Created
September 18, 2017 14:49
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
| 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)')), |
Everettss
/ start-tasks.sql
Last active
September 18, 2017 14:39
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
| SELECT task, (count(distinct projectID) / 107646 * 100) as percent | |
| FROM [scripts] | |
| WHERE taskName = 'start' | |
| GROUP BY task | |
| ORDER BY percent DESC |
Everettss
/ test-tasks.sql
Last active
September 18, 2017 14:13
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
| SELECT task, (count(distinct projectID) / 202808 * 100) as percent | |
| FROM [scripts] | |
| WHERE taskName = 'test' | |
| GROUP BY task | |
| ORDER BY percent DESC |
NewerOlder