Bookmarks and Browsing History: The places.sqlite file contains all your Firefox bookmarks and the list of all the websites you’ve visited ...
Autocomplete history: The formhistory.sqlite file remembers what you have searched for in the Firefox search bar and what information you’ve entered into forms on websites ...
Download history: The downloads.sqlite file remembers what you have downloaded. ...
As you can see, all three histories are not simple text files but database files in sqlite format.
One way to view .sqlite files is by using sqlite3 (sudo apt-get install sqlite3).
Open a terminal and cd to the folder containing what you want to view. In my case, that is ~/.mozilla/firefox/w4wcp85s.default.
ls *.sqlite lists the sqlite files.
Run sqlite3 places.sqlite (if places.sqlite is what you want to view). You'll see something like this:
$ cd ~/.mozilla/firefox/w4wcp85s.default
$ sqlite3 places.sqlite
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
Now, there are several things you can do. (Use Ctrl+D to exit sqlite3).
For example, typing .tables and pressing Enter gives me:
To view the contents, type SELECT * FROM table_name; (where table_nameis the name of the table you wish to view; note the ;) and press Enter. It's quite likely that the output won't be understandable but that is not the fault of sqlite3.
To show you an example that does provide decent output, look at stylish.sqlite (if you use the Stylish extension):
$ ~/.mozilla/firefox/w4wcp85s.default $ sqlite3 stylish.sqlite
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
style_meta styles
sqlite> SELECT * FROM styles;
6||||YouTube|/* AGENT_SHEET */
/* ▓▓ NIGHTSHIFT - eye care: ▓▓
▓▓_http://userstyles.org/styles/18192/nightshift-eye-care_▓▓ */
@namespace url(http://www.w3.org/1999/xhtml);
@-moz-document regexp("https?://www.youtube.com/.*") {
body,html {min-height: 100%!important; }
html, body{background-color:#111!important}
You can do everything in just one non-interactive command if you know exactly what you want. Read The sqlite3 command line tool for more on sqlite3.
$ sqlite3 stylish.sqlite "SELECT * FROM styles;" > ~/Desktop/filename.txt
will do the needful in the example given and tee will let you see the output on screen as well:
$ sqlite3 stylish.sqlite "SELECT * FROM styles;" | tee ~/Desktop/filename.txt
This short command cleans Firefox backups, cache, cookies, crash reports, DOM storage, download history, form history, passwords, session restore, site preferences, and URL history (as of BleachBit 1.8):
According to this mozillazine page the history for the browser is stored in places.sqlite file in the profiles folder (.mozilla/firefox/ on Ubuntu.)
So, I pulled that file up and took a look at the tables within the database. Within the moz_places table there is a column last_visit_date which provides you with an Unix time/Epoch time number.
However, there are no other columns that provide a number for initial visit and thus no way to provide a true browser history other than the one that Firefox themselves provide.
TL;DR: As far as I can tell by looking at the Firefox SQLite files, there is no way to get a full history other than the one the browser provides.
EDIT: I have created a basic Firefox addon that will write the date & time (in Unix/Epoch format) along with the page title and page URL to the firefoxHistory file in your home directory.
Best Answer
This page describes what user-specific information is stored by Firefox and where. (And this is what Mozilla's help has to say on viewing .sqlite files.)
It lists three types of history:
Bookmarks and Browsing History: The places.sqlite file contains all your Firefox bookmarks and the list of all the websites you’ve visited ...
Autocomplete history: The formhistory.sqlite file remembers what you have searched for in the Firefox search bar and what information you’ve entered into forms on websites ...
Download history: The downloads.sqlite file remembers what you have downloaded. ...
As you can see, all three histories are not simple text files but database files in
sqlite
format.One way to view
.sqlite
files is by usingsqlite3
(sudo apt-get install sqlite3
).Open a terminal and
cd
to the folder containing what you want to view. In my case, that is~/.mozilla/firefox/w4wcp85s.default
.ls *.sqlite
lists the sqlite files.Run
sqlite3 places.sqlite
(if places.sqlite is what you want to view). You'll see something like this:Now, there are several things you can do. (Use Ctrl+D to exit sqlite3).
For example, typing
.tables
and pressing Enter gives me:To view the contents, type
SELECT * FROM table_name;
(wheretable_name
is the name of the table you wish to view; note the;
) and press Enter. It's quite likely that the output won't be understandable but that is not the fault of sqlite3.To show you an example that does provide decent output, look at
stylish.sqlite
(if you use the Stylish extension):You can do everything in just one non-interactive command if you know exactly what you want. Read The sqlite3 command line tool for more on sqlite3.
will do the needful in the example given and
tee
will let you see the output on screen as well:(Thanks due here.)