I opened places.squlite in "DB Browser for SQLite" program. But I can't see the URLs or webpage titles or easy-to-read timestamps in the moz_historyvisits table.
I made a copy of the places.sqlite file and put that copy into my Documents folder. I then downloaded DB Browser for SQlite (https://sqlitebrowser.org/).
I opened the places.sqlite in the program. I click on the "Browse Data" tab. I then click the dropdown list for the "table", and choose "moz_historyvisits". But I don't see any understandable information.
I was expecting to see URLs, titles of the webpages, and possibly having the visit date in some easy-to-read format. can anyone help please?
Modified by Mozilla cheese
All Replies (1)
Hi Mozilla cheese, are you familiar with writing SQL queries or creating database views?
places.sqlite is a relational database, which favors compactness over convenience. In order to construct a complete picture, you need to join tables. For example, moz_historyvisits contains a place_id column which refers to the id column of the moz_places table. That is where you find the URL of the "place" that was visited.
You could try this on the Execute SQL tab:
SELECT datetime(visit_date/1000000,'unixepoch') AS VisitDateTime, url, title
FROM moz_places INNER JOIN moz_historyvisits
ON moz_historyvisits.place_id = moz_places.id
WHERE url LIKE '%://support.mozilla.org/%'
ORDER BY visit_date DESC
This query finds URLs on support.mozilla.org in moz_places and dumps out all the visits to those URLs in reverse chronological order. It includes a function to reformat the numeric visit_date value to a more recognizable date-time.
Please ignore the way the forum finds and linkifies text in the above, they are not intended to be hyperlinks.
If you remove the WHERE clause, the DB Browser should list everything.
The rabbit hole is deep, so that's only the barest glimpse.