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.


Don't forget to pay my friend a visit too. Joakim