This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

SQL command insert / delete bookmark

  • 1 reply
  • 1 has this problem
  • 4 views
  • Last reply by cor-el

more options

Hi, what SQL command is executed when a bookmark ist dragged from the adress bar to the bookmark menue? what SQL command is executed when a bookmark ist deleted from the bookmark menue? For example what do I have to enter in SQLite manger?

Hi, what SQL command is executed when a bookmark ist dragged from the adress bar to the bookmark menue? what SQL command is executed when a bookmark ist deleted from the bookmark menue? For example what do I have to enter in SQLite manger?

All Replies (1)

more options

You would have to change the folder ID if you want to move a bookmark. To remove a bookmark there are two main tables moz_bookmarks and moz_places and possible links to moz_keywords and tables that deal with annotations (moz_annos, moz_anno_attributes) and moz_favicons. You can see that this can require a lot of work if you want to do this properly.

Some files that have SQL statements that deal with bookmarks. https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/Bookmarks.jsm https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/Database.cpp https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/PlacesDBUtils.jsm https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/nsNavBookmarks.cpp

Maybe try to ask at the Reddit forum.