Websites where we spend the majority of our time.Here I brainstorm some of the historical trends we will be able to uncover: We can (1) perform a historical analysis on the data, as well as (2) do real-time monitoring of the data. We can even use om_visit to figure out what website linked us to each url, if that interests us. We can see what website we visited ( visits.url), when we visited it ( visits.visit_time), how many times we’ve visited it ( urls.visit_count), and how long each visit was for ( visits.visit_duration). The amount of time spent at the website, or 0 if not available.Īs you can see, we can access every visit to every website that we’ve made since the last time we cleared our browsing history. I’m not quite sure what a segment is, but there is a segments table you can look at. The id of the visit that lead you to this one. The number of times you’ve visited the URL by typing in the address (as opposed to by following a link.)Īnd the visits table has these columns (obtained via. The number of times you’ve visited the URL. The urls table has these columns (found with. We’ll be most interested in the urls and visits tables. tables, we see the following tables are available. However you most like scripting, you’ll have a familiar way of accessing the data. There are also libraries available for accessing sqlite3 databases in just about every language. This means you can browse it interactively using the sqlite3 REPL by running sqlite3 PATH_TO_DATABASE. Before analyzing the data, I recommend making a copy of it ( cp ~/Library/Application\ Support/Google/Chrome/Default/History my-history) this way your history database (a) won’t be locked by Chrome while you’re trying to access it, and (b) won’t change while you’re looking at it, which could cause confusion and inconsistencies in your results. located at ~/Library/Application Support/Google/Chrome/Profile 1/History.Įach browsing history is stored as a sqlite3 database. Since I use multiple profiles in Chrome, each profile gets its own browsing history, e.g. My Chrome browsing history is located at ~/Library/Application Support/Google/Chrome/Default/History. In this post, I’ll just focus on Chrome on OSX, since that’s my primary mode of browsing. The gist covers Safari, Chrome, and Firefox. This gist explaining how to access your browser history via sqlite3. , I already have a chat bot system in place, which will be able to take advantage of this data to e.g. Then, let’s discuss what you can do with this data. Really exciting! This is rich data, from which I think I’ll be able to learn a lot and hopefully combat unwanted distractions.įirst let me describe what information is available, and how you can access it. I’ve learned recently that programmatically accessing your browsing history is rather straightforward.
0 Comments
Leave a Reply. |