For the author's stated use-cases, it would be easier to do this via. a chrome extension. Relevant documentation: <a href="https://developer.chrome.com/docs/extensions/reference/history/" rel="nofollow">https://developer.chrome.com/docs/extensions/reference/histo...</a><p>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)<p>Hope this helps
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: <a href="https://github.com/bencaradocdavies/sqlite-mozilla-url-hash" rel="nofollow">https://github.com/bencaradocdavies/sqlite-mozilla-url-hash</a><p>In short, there's a FF-specific hashing function that's needed when updating and inserting new rows.