Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

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

Avatar of ThomasReimann
ThomasReimann asked on
DatabasesWeb Browsers
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
Avatar of Greg Wright
Greg WrightFlag of United States of America imageSr. Database Administrator

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

Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answers