Skip to content

Instantly share code, notes, and snippets.

@dmitryvk

dmitryvk/gist:8db1c4711cf76a08b231

Last active August 29, 2015 14:07
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 dmitryvk/8db1c4711cf76a08b231 to your computer and use it in GitHub Desktop.
Save dmitryvk/8db1c4711cf76a08b231 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sh-session
$ cd ~/.config/chromium/Default
$ sqlite3 History "select date(t0.visit_time / 1000000 - 11644473600, 'unixepoch', 'localtime'), count(*) from visits t0 join urls t1 on t0.url=t1.id and t1.url='https://twitter.com/' group by 1 order by 1 desc limit 10"
$ sqlite3 "Archived History" "select date(t0.visit_time / 1000000 - 11644473600, 'unixepoch', 'localtime'), count(*) from visits t0 join urls t1 on t0.url=t1.id and t1.url='https://twitter.com/' group by 1 order by 1 desc limit 10"
2013-06-19|1
2013-06-18|8
2013-06-17|35
2013-06-16|3
2013-06-15|11
2013-06-14|30
2013-06-13|34
2013-06-12|30
2013-06-11|21
2013-06-10|44
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment