Google Chrome History Plugin

[appetizermonster]

History data can be found at %AppData%\Local\Google\Chrome\User Data\Default\History. and this is a SQLite database file.

[tehbilly]

Went to implement this yesterday evening, ran into two issues:

• SQLite database is locked constantly, but can be safely (and quickly) copied before opening.
• The sqlite package I was using did not compile correctly for running inside of electron, and I didn't have time to get electron-rebuild going.

Less than helpful than submitting a full plugin, but figured those points may be useful if someone else wants to run at the problem. Can share queries/skeleton code I used if someone would like to have a go at it.

[bayleedev]

The bookmarks are stored in a json file, which might be easier to use. You can see the alfred chrome bookmarks for reference on this.

The alfred plugin that does chrome history copies the db file for 60 seconds, although I think it could be closer to 30+ minutes depending on your needs, since this copy operation is the slowest part of the all this. I couldn't find the source on github, but the workflow is on github and I added the relevant source to a gist.

[tehbilly]

I think caching the db file for a (configurable!) short amount of time would be good without impacting search performance. Copying, querying, searching (with fuzzy package) happens on my windows machine in less than 100ms on average. The sqlite native component is the only thing that bothers me (I'm not a node guy!).