Reading Firefox Bookmarks

Question

Apparently, latest Firefox versions stores its bookmarks in a file called 'places.sqlite'. Like a browser can import the bookmarks from another browser, I would want to import the bookmarks to a file, but I need to know what would you need to do it?

Answer 1

Try using SQLite DBC driver. http://www.zentus.com/sqlitejdbc/

Answer 2

SQLite is an embedded, serverless, relational database. Besides the mentioned ODBC drivers, it has its own C API.

Answer 3

You can try the SyncPlaces Firefox extension, some kind of successor of the old Bookmarks Synchronizer which is no longer maintained.

I use it to keep my bookmarks and cached passwords on Firefox on several computers in sync.

The file format it uses for export is XBEL, an XML based format, which was originally designed for a Python bookmarks management program, and which you might probably be able to use in your C++ program.

In principle, if you link to the SQLite library, you can access *.sqlite files directly using SQL. Or, if it's a one shot program, you can try SQLite Browser to open such a file and export the tables to CSV.