Dilantha Redux

Code and other stuff

SQL Play With Firefox 3 Places

I heard good things about Firefox 3. Now that I’ve got Ubuntu 8.04 I thought I’d try a few commands. 1. Get the places database 2. open with sqlite 3. query the bookmarks table cp .mozilla/firefox/xxxxxxxx.default/places.sqlite . sqlite3 places.sqlite sqlite> .tables moz_anno_attributes moz_favicons moz_keywords moz_annos moz_historyvisits moz_places moz_bookmarks moz_inputhistory moz_bookmarks_roots moz_items_annos sqlite> select * from moz_places limit 1; 1|place:queryType=0&sort=8&maxResults=10|queryType=0&sort=8&maxResults=10||0|1|0||0 Happy data mining!