Access the history database
Chromium (53) stores it's history in a SQlite3 database.
Install sqlite tools:
sudo apt-get install sqlite
Then go to the place in your home folder where it is stored as History:
cd ~/.config/chromium/Default
Make sure Chromium is not running, if it is it will lock the file.
Also make sure that you start sqlite3 client and _not_ sqlite client - if you do, you will find that every command you try tells you that the database is encrypted.
sqlite3 History
You should now have a sqlite> prompt.
To get help, type .help
To show databases, type .databases
To show tables, type .tables
To show table columns (shows original create query): .schema table-name-here
Example query to list when a specific file finished downloading:
SELECT target_path, datetime(end_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch') FROM downloads WHERE downloads.target_path LIKE '%Insert-Part-Of-The-Filename-Here%';
This is a personal note. Last updated: 2016-12-01 00:07:10.



