4 ms·
made me curious how many search queries I'm doing: averaging 2000/month: sqlite3 ~/.mozilla/firefox/*default*/places.sqlite "select strftime('%Y/%m', last_
by flas9sd 4y ago
made me curious how many search queries I'm doing: averaging 2000/month:
sqlite3 ~/.mozilla/firefox/*default*/places.sqlite "select strftime('%Y/%m', last_visit_date/1000000, 'unixepoch') as yearmonth, substr(p.url,9,14) as search_backend,count(1) as hits from moz_places p where (p.url like 'https://duckduckgo%' or p.url like 'https://www.google.%/search%' or p.url like 'https://www.qwant%') group by search_backend,yearmonth order by yearmonth asc,hits desc;"
add any search engine you use with another 'p.url like'