Advanced Search

Return to Snippet

Revision: 70950
at October 15, 2016 04:19 by rm1984
Initial Code 
#!/bin/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}' "${HOME}/.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
Initial URL 
https://raymii.org/s/snippets/Firefox_History_Stats_with_Bash.html
Initial Description 
This is a small script to gather some statistics from your Firefox history. 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 them.
Initial Title 
Firefox history stats with Bash
Initial Tags 
Bash
Initial Language 
Bash