Firefox history

This is a wiki page. Be bold and improve it!

If you have any questions about the content on this page, don't hesitate to open a new ticket and we'll do our best to assist you.

Update this page with any information that is relevant one way or another to the browsing history within firefox.

History is stored together with bookmarks in a database file named places.sqlite.
~/.mozilla/firefox/{xxx}.default/places.sqlite
where {xxx} can be the host name or something else.

See sqlite for working with .sqlite files.

Sample query to browse the history from the command line:

$ sqlite3 ~/.mozilla/firefox/NNN.default/places.sqlite
sqlite> select h.*, datetime(visit_date/1000000,'unixepoch') AS visit_date, p.url  from moz_historyvisits h join moz_places p on p.id = h.place_id order by visit_date ASC;