Question

How to search and filter history in sqlite3?

3 মাসসমূহ আগে

30/10/25 4:24 PM

How to search and filter history on specific values like url, title, date/time visited in sqlite3?

Thankyou ab2qik.

How to search and filter history on specific values like url, title, date/time visited in sqlite3? Thankyou ab2qik.

Answer 1 · 2025-10-30 16:24:25.888963

31/10/25 4:58 AM

You can use this kind of select:

SELECT datetime(h.visit_date/1000000,'unixepoch'), p.url, p.title
FROM moz_places p, moz_historyvisits h 
WHERE p.id = h.place_id