SQ Lite {Tools}

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

• explore SQLite file
  • .table to list available tables
• sqlite -init linkschecked.sql linkschecked.sqlite
  • execute the sql commands on the sqlite database
  • note that sqlite does not stop after
    • add .quit to leave the session
• error messages are often wrong
  • e.g. encrypted database while permission are missing
    • happens often to get to create a lock in the directory for the DB, even as read only default mode (!)
• Date And Time Functions
• SELECT
  • used in DrumbeatParis#VisitedLinks
• clients
  • Command Line Shell For SQLite especially practical for Cognition#AnalysisOfTheUsageHistoriesOfTools
  • SQLite Manager in XUL thus usable within Firefox
    • http://code.google.com/p/sqlite-manager/wiki/FAQ#Is_it_possible_to_save_queries?
  • SQLiteSpy by Delphi Inspiration with Time Measurement support
  • Sqliteman

From YetAnotherTutorial

• this does that
• this other command is nice

To explore

• links to websites with content to discover

Note

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.