With the advent of Firefox 3, everybody is talking about the new bookmark system. Most like it, while some don’t. But the major confusion among the new people who have started using Firefox 3 is the question, where are the Firefox 3 bookmarks stored or saved?
Where were bookmarks saved before?
In Firefox 2, the bookmarks were stored in bookmarks.html file under C: Users –> <User Name> –> AppData –> Roaming –> Mozilla –> Firefox –> Profiles –> (some random characters.default ex 2xd8htj.default) –> Bookmarks.html
Even though you find this file in Firefox 3, you may find that it doesn’t have the latest bookmarks you have added in Firefox. You may find only the imported bookmarks in that file. That’s because Firefox 3 bookmarks are not stored in the same way it was stored before. (Note: You can tweak Firefox 3 to save bookmarks in bookmarks.html also)
Where are bookmarks saved in Firefox 3 now?
It stores both the bookmarks and the history as the database with the help of SQLite. This is the reason why Firefox 3 is able to add tags to the bookmarks and the awesomebar is able to list the suggestions as per most visited links. This also enable Firefox 3 to handle these requests very fast. SQLite database bookmark system was added since Firefox 3 Alpha 5 – Mozilla Development Center.
So in the same place where you found bookmarks.html, you will find places.sqlite and this is the database which handles all the Firefox 3 bookmarks.
So what is JSON and what has to do with Bookmarks?
So now how to view bookmarks in places.sqlite?
The best way is to install the SQLite Manager addon which helps to view all the 11 tables that are present in the bookmark database. This includes table for history, favicons, keywords, bookmarks root etc.
Once you install the addon, click Connect Database and browse to select places.sqlite and you can view all the bookmarks in the table moz_bookmarks. If you prefer to do it this way, you can also manually add, edit or delete bookmarks through this table.