Docunext

  • About

Make Places

October 10th, 2009
#!/bin/bash

sqlite3 -csv .mozilla/firefox/10p23dd5.default/places.sqlite "SELECT url,substr(last_visit_date,0,11) from moz_places WHERE url NOT LIKE 'https%';" > moz_places.csv

cat moz_places.csv | grep google.com/search | sed -r s/.+[?\&]q=/\"/ | sed -r s/\&[^,]+,/\"\ =\>\ / | sed -r s/$/,/ | sed s/+/_/g | tr '[:upper:]' '[:lower:]' | sort | uniq -w 20 > searches.rb

echo 'places = {\n' > newserch.rb
cat searches.rb | grep "=" | grep -e "^\"" >> newserch.rb
echo '\n}' >> newserch.rb
Yearly Indexes: 2010 2003 2005 2006 2007 2008 2009 2004 2011 2012 2013 2015 2019 2020