Kmanc Kmanc - 8 months ago 42
Python Question

Where (and what) can I find in local Google Chrome sql databses?

I'm trying to work my way through the book "Violent Python", and I'm on chapter 3... The exercise walks you through writing some Python scripts to grab Firefox data from the locally stored sql dbs - cool stuff! But now I want to see if I can do the same for Chrome. I've seen on some websites that I should be able to find a "urls" db, but I can't seem to figure out where it is.

I've found the Databases.db file, which has tables "databases", "meta", and "sqlite_sequence". Am I on the right track here? I want to find things like internet history, bookmarks, etc.



If you are on windows you'll find the sqlite db for chrome history here:

C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\Default\History

On Linux:


On MacOS-X:

/Users/$USER/Library/Application Support/Google/Chrome/Default/History

For more Information look here:

I advise you to use: to look through the history file. enter image description here