Skip to content

Instantly share code, notes, and snippets.

@patrickdevivo

patrickdevivo/count_package_json_deps.sql Secret

Last active October 27, 2021 10:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save patrickdevivo/9620054f6f7611a1436b95957f8d49b9 to your computer and use it in GitHub Desktop.
Save patrickdevivo/9620054f6f7611a1436b95957f8d49b9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
count_package_json_deps.sql
SELECT
count(*), deps.key
FROM package_json, json_each(package, '$.dependencies') deps
WHERE json_valid(package) = 1
GROUP BY deps.key ORDER BY count(*) DESC LIMIT 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment