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!