troubleshooting Question

How does Firefox reference Bookmarks to Tags in places.sqlite?

Avatar of ThomasReimann
ThomasReimann asked on
Web BrowsersDatabases
1 Comment1 Solution737 ViewsLast Modified:
Firefox Bookmarks are saved in the table moz_bookmarks in the database file places.sqlite.

see table overview: http://www.forensicswiki.org/wiki/Mozilla_Firefox_3_History_File_Format

a single bookmark may look like this:

id 77 type 1 fk 73 parent 3 position 1 title Google

now I add two Tags to this bookmark in Firefox. Lets name them tag1 and tag2.

The line of the Google bookmark is not changed in the moz_bookmarks table.

Instead the two new tags are added to the end of the table.

example for "tag1":

id 120 type 2 fk (empty) position 0 title tag1

--------

I want to know where Firefox is linking the Google Bookmark to the newly created Tag. There is no reference in the Google Bookmark table entry to tag1 or tag2.

I've looked in every other table of places.sqlite (using SQLite Database Browser, you can get it at SourceForge) and I see nowhere a link between the bookmark and the tags.

Documentation on this subject is very sparse and often 2 years old. The Firefox source code consists of 60.000 files, so it's not easy to do anything with it quickly.
ASKER CERTIFIED SOLUTION
Greg Wright
Sr. Database Administrator

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros