How to search and filter history in sqlite3?

há 6 meses

30/10/2025 16:24

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 23:24:25.888963+00:00

31/10/2025 04:58

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