Differences

This shows you the differences between two versions of the page.

--- web_browsers:firefox_history_stats [2016/07/04 08:50] – created peter
+++ web_browsers:firefox_history_stats [2020/04/15 11:57] (current) – removed peter
@@ Line 1: / Line 1: @@
-====== Web Browsers - Firefox History Stats ======
-First we use **sqlite3** to parse the Firefox history database and get the last three months, then we remove all the IP addresses and port numbers and finally we sort and count it.
-<code bash>
-if [[ ! -d ${HOME}/.www ]]; then
-mkdir ${HOME}/.www/
-fi
-cp "$(find "${HOME}.mozilla/firefox/" -name "places.sqlite" | head -n 1)" "${HOME}/.www/places.sqlite"
-sqlite3 "${HOME}/.www/places.sqlite" "SELECT url FROM moz_places, moz_historyvisits \
-                       WHERE moz_places.id = moz_historyvisits.place_id \
-                             and visit_date > strftime('%s','now','-3 month')*1000000 ORDER by \
-                       visit_date;"  > "${HOME}/.www/urls-unsorted"
-sort -u "${HOME}/.www/urls-unsorted" > "${HOME}/.www/urls"
-awk -F/ '{print $3}' .www/urls | grep -v -E -e '[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}' -e ':.*' -e '^$' | sed -e 's/www\.//g' |sort | uniq -c | sort -n
-</code>
-Example output:
-<code>
-lowendtalk.com
-reddit.com
-google.com
-github.com
-encrypted.google.com
-i.imgur.com
-next.duckduckgo.com
-duckduckgo.com
-wiki.int
-management.int
-</code>