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 QuestionDid 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?
ThomasReimann asked on
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.
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.