![]() ![]() To query for results from today, we can do the following. Where urls.url like "%and datetime(last_visit_time / 1000000 (strftime('%s', '')), 'unixepoch') What was I searching for on Christmas last year? select DISTINCT REPLACE(urls.title, " - Google Search", "") To filtering by a specific date, we just add. select DISTINCT REPLACE(urls.title, " - Google Search", "") Here’s the query we had from before, for accessing our Google Search history. cp ~/Library/Application\ Support/Google/Chrome/Default/History ~/my-history To run these queries, first make a copy of your browser history and open it in sqlite3. Google Chrome selects a slightly non-standard time storage format (microseconds since JanuUTC), hence the need for this query stanza. In this snippet, I show how to amend them to filter the results by date. Number of SQL queries for browsing my browsing history. ![]()
0 Comments
Leave a Reply. |