Skip to content

Instantly share code, notes, and snippets.

@stnbu

stnbu/get_firefox_bookmark_tags

Last active August 29, 2015 14:17
Show Gist options
  • Save stnbu/9559b007267a57265041 to your computer and use it in GitHub Desktop.
Save stnbu/9559b007267a57265041 to your computer and use it in GitHub Desktop.
Download ZIP
Recover Tag Information From Firefox Bookmarks
Raw
get_firefox_bookmark_tags
-- recover firefox bookmark tags
-- --------------------------------------
-- List known tabs
SELECT id, title FROM moz_bookmarks WHERE fk IS NULL AND title IS NOT NULL;
-- List bookmarks tagged with id=1300
SELECT moz_places.id, moz_places.url, moz_places.title, moz_bookmarks.parent
FROM moz_places
LEFT OUTER JOIN moz_bookmarks
ON moz_places.id = moz_bookmarks.fk
WHERE moz_bookmarks.parent = 1300
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment