Read Firefox 3 bookmarks

Question

Firefox 3 stores the bookmarks in a sqlite database. There are several hacked sqlite java libraries available. Is there a way to hack the sqlite database in java(not using libraries) to read bookmarks reliably? Does someone know how the sqlite DB is stored and access programmatically (from java)?

Answer 1

You need the SQLite JDBC driver (this page explains how to run queries on a SQLite database using that driver from within Java).

Answer 2

This may sound moronic but are there any solutions without using JDBC driver?

Answer 3

I don't know why you need NOT to use a JDBC driver, but there's another possible "solution" depending on your software requirements. In FF3, type in the address bar about:config

Alter the value of property: browser.bookmarks.autoExportHTML to true.

This will export your bookmarks in an HTML whenever you close FF. You can then read the HTML. It may or may not solve your problem....

Answer 4

I am aware of autoexport option. That needs user intervention there no documented way to set it programatically.

JDBC require JNI nonsense which is a pain for cross platform portability in my case

Answer 5

I'm on the same boat, it looks like older versions of FireFox used to store it in a file. I need to crack this.

Answer 6

Look http://sqljet.com/