Created
January 10, 2017 14:13
-
-
Save dmajda/e5e945ecf104881b6d4091c00c8cf04a to your computer and use it in GitHub Desktop.
Determining percentage of HTTPS URLs in my browser history
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
On (Arch) Linux: