29

Is there a command to show Firefox history from the Terminal ?

without the need to Enter Firefox history graphically .

  • Could you add the reason for wanting to do so? – user25656 Jan 30 '14 at 2:22
  • Why do you not want to use Firefox itself? – user25656 Jan 30 '14 at 8:29
  • 1
    @user25656: If you want to be fast, use the command line. You can do statistics out of it. You can search with regular expressions (e. g. using grep), you can create graphs, etc. Everything not possible inside firefox. At least not without hacking an addon. – erik Mar 12 '17 at 2:01
28

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 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:

sqlite> .tables
moz_anno_attributes  moz_favicons         moz_items_annos    
moz_annos            moz_historyvisits    moz_keywords       
moz_bookmarks        moz_hosts            moz_places         
moz_bookmarks_roots  moz_inputhistory   
sqlite> 

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 

(Thanks due here.)

  • If you want to search all databases and all tables in that databases for a specific term (e. g. stackoverflow.com), you can just do (as a one-liner): for DATABASE in *sqlite; do echo -e "********\n$DATABASE\n********";for TABLE in $(sqlite3 $DATABASE ".tables"); do echo -e "========\n$TABLE\n========"; sqlite3 $DATABASE "select * from $TABLE;"; done; done | grep 'stackoverflow\.com' Or instead of grep use less and search inside the results. – erik Mar 12 '17 at 1:57
  • Something like this is just going to roll off the end of my ~/.bash_history, so I wrote a Python (3.5+) script using the Click library to make basic listing, sorting, and filtering a lot easier. You can get it from this Gist. Please leave comments there if you run into problems. – TheDudeAbides May 12 '18 at 1:40
6

Here is what I ended up with (thanks to previous answers):

db=$(find "${HOME}/.mozilla/firefox/" -name "places.sqlite")
query="select p.url from moz_historyvisits as h, moz_places as p where substr(h.visit_date, 0, 11) >= strftime('%s', date('now')) and p.id == h.place_id order by h.visit_date;"
todays_urls=$(sqlite3 "${db}" "${query}")
echo "${todays_urls}" > todays_urls
  • 1
    Actually the most-useful-copy-paste-non-verbose solution. Thanks. – vmassuchetto Dec 4 '17 at 20:41
  • If you have several Firefox profiles, you need to add | head -1 to the find command. – mivk Mar 17 at 2:46
3

On my Xubuntu 13.10 it's on

/home/myusername/.mozilla/firefox/nod2ejl8.default/places.sqlite

Or you could

find / -name 'places.sqlite

Since it's an *.sqlite file, you can install this vim plugin and use vim, search for a way to open an sqlite file from terminal. More information can be found here.

  • 1
    ~/.mozilla/firefox/*.default/places.sqlite should work – mchid Sep 7 '15 at 17:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.