Skip to content

Instantly share code, notes, and snippets.

@dmajda

dmajda/sqlite-history-https.txt

Created January 10, 2017 14:13
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 dmajda/e5e945ecf104881b6d4091c00c8cf04a to your computer and use it in GitHub Desktop.
Save dmajda/e5e945ecf104881b6d4091c00c8cf04a to your computer and use it in GitHub Desktop.
Download ZIP
Determining percentage of HTTPS URLs in my browser history
Raw
sqlite-history-https.txt
$ sqlite3 History 1 ↵
SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter ".help" for usage hints.
sqlite> SELECT COUNT(*) FROM urls WHERE url LIKE 'https://%';
20231
sqlite> SELECT COUNT(*) FROM urls;
29485
sqlite> SELECT 20231 / 29485.0; -- `.0` forces float division
0.6861454977107
@dundee
Copy link

dundee commented Jan 10, 2017 •
edited

On (Arch) Linux:

sqlite3 ~/.config/chromium/Default/History

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment