Skip to content

Instantly share code, notes, and snippets.

@patrickdevivo
Created Sep 11, 2021
Embed
What would you like to do?
-- average time (in days) since a line of code was last modified
SELECT
AVG(julianday(datetime('now')) - julianday(author_when)) AS avg_age
FROM files, blame('', '', path)
JOIN commits ON hash = commit_hash ORDER BY avg_age
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment