from Hacker News

Planning to Analyze My Browsing History (2019)

by dbieber on 8/15/22, 2:49 AM with 4 comments

• by bluelightning2k on 8/15/22, 9:04 AM

  For the author's stated use-cases, it would be easier to do this via. a chrome extension. Relevant documentation: https://developer.chrome.com/docs/extensions/reference/histo...

  Interesting note: the visits.visit_duration column is not exposed through this API (or at least - not listed in the documentation). This may be because it's apparently misleading. (It apparently captures the time the tab was open not the time the tab was active)

  Hope this helps

• by klibertp on 8/15/22, 10:21 AM

  Somewhat related, as history seems to be kept in the same sqlite db as the bookmarks, at least for Firefox. If you want to update the entries there (as opposed to just reading and filtering them) you will want this: https://github.com/bencaradocdavies/sqlite-mozilla-url-hash

  In short, there's a FF-specific hashing function that's needed when updating and inserting new rows.

• by 1MachineElf on 8/15/22, 6:30 AM

  It's being analyzed whether you like it or not by many powerful tech companies. Putting that power into your own hands is a good thing.