Skip to content

Instantly share code, notes, and snippets.

@dacort

dacort/gist:f480bb3b99817dbbefdb

Created April 23, 2015 06:19
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 dacort/f480bb3b99817dbbefdb to your computer and use it in GitHub Desktop.
Save dacort/f480bb3b99817dbbefdb to your computer and use it in GitHub Desktop.
Download ZIP
Extract Github URL counts from Chrome history
Raw
gistfile1.txt
sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/History "SELECT date(visit_time/1000000-11644473600, 'unixepoch'),urls.url,count(*) FROM visits INNER JOIN urls ON visits.url = urls.id WHERE urls.url LIKE '%github.com/%' GROUP BY date(visit_time/1000000-11644473600, 'unixepoch'),urls.url ORDER BY date(visit_time/1000000-11644473600, 'unixepoch') DESC,count(*);"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment