Display every visit to every url

Is there a way to display every visit to every url, including date/time of each visit?

It kind of enrages me that when viewing “complete history” it shows only the most recent visit to any given url.

When Brave is installed on macOS, every visit to every url is logged in a sql lite database. You can download SQLPro for SQLite and run in trial mode forever. Just keep clicking continue trial when starting it up. So, use any sql lite client you want, and open the database stored at /Users/dan/Library/Application Support/BraveSoftware/Brave-Browser/Default/History

That path to the db is for macOS. Windows runs the same db, but you have to find the Windows location.

Then run this sql

select
v.id,
u.url,
u.title,
v.visit_time,
datetime(v.visit_time / 1000000 + (strftime(‘%s’, ‘1601-01-01’)), ‘unixepoch’, ‘localtime’) as visit_time
from visits v
left join urls u on v.url = u.id
order by v.visit_time desc

The major trick in that sql is translating the visit_time to date/time format. I forgot where I got the secret formula, but it works awesome.

The results come back looking like this:

1 Like