Originally in Tools#SQLite

See the related scripts e.g. browser_queries.

Exploring browsing history

Exploring Firefox history .mozilla/firefox/*/places.sqlite

select (count(*)/ ((max(visit_date) - min(visit_date))/(24*60*60*1000000)) ) from moz_historyvisits inner join moz_places on moz_historyvisits.place_id = moz_places.id where url like "";

Resulting in 3, so an average of 3 visits per day over a period of approximately 3 years, between now (December 2022 to October 2019). Note that this is limited to 1 computer (possibly more, unsure how history works with Firefox Account) or at least not a work computer that can't be synced.

Limiting to action=search returns only 87 results.

See past example in ImprovingPIM.

From personal use

From YetAnotherTutorial

  • this does that
  • this other command is nice

To explore

  • links to websites with content to discover


My notes on Tools gather what I know or want to know. Consequently they are not and will never be complete references. For this, official manuals and online communities provide much better answers.