Does Safari browser history DB contain transition type?
4
votes
0
answers
1183
views
The browser history of **Safari** is stored in
~/Library/Safari/History.db
which is a regular **SQLite** database. For example, it can be viewed using SQLite Browser or queried using Python .
The database contains a table named history_items
. This lists all *URL*'s, with their *title*, and *id* and the total number of time the website was *visited*. Another table is named history_visits
. This lists all individual *visits*, with a *timestamp*, *id* and, possibly, information about the source which *redirected* the user to this website.
In the **Chrome** browser history, the *transition type* is also stored . This notes whether the user arrived at the website via a *link*, a *reload* or whether he *typed* in the address directly. Is such transition information also available in the Safari History.db
?
The table history_visits
also contains integer columns named *origin*, *generation* and *attributes*. However, it is unclear to me what these mean. Is there a documentation available for the Safari browser history database?
Asked by LBogaardt
(101 rep)
Apr 25, 2019, 08:58 AM
Last activity: Apr 27, 2019, 04:53 PM
Last activity: Apr 27, 2019, 04:53 PM