Does anyone know how to open this places.sqlite firefox database file? I'm
told it holds all of my browsing History files which I would like
to examine.

don, 17.03.2009 05:12:
As the extension indicates, it's a SQLite database.

Check out: http://www.sqlite.org/

I can successfully open it with a JDBC (Java) based query tool and the SQLite JDBC driver.

Thomas

Thomas Kellerer <YQDHXVLMUBXG (AT) spammotel (DOT) com> writes:

I haven't used it, but shouldn't sqlite3 be able to work with the file
as well?
--
Chetan
What's news?

On Apr 2, 7:05Â*pm, Chetan <chetan.xs... (AT) xspam (DOT) sbcglobal.net> wrote:
Yes.

$ sqlite3 ~/.mozilla/firefox/XXXXX.default/places.sqlite
SQLite version 3.3.5
Enter ".help" for instructions
sqlite> select * from moz_favicons limit 3;
2|http://www.mozilla.org/2005/made-up-favicon/1-1234317671553315||
image/x-icon|0
4|http://www.mozilla.org/2005/made-up-favicon/3-1234317671555757|�PNG



don wrote:
You can try http://code.google.com/p/sqlite-manager/ which is a firefox
extension.
It can manage any sqlite database and gives shortcuts to the ones of
your firefox profile including places.