Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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