Prefered sqlite3 settings

.headers on
.mode columns

Helpers

Sqlite funtion to convert string time stamp to unix epoch:

strftime('%s', 'time')

Ideas

When naming indexes can name them after the query they support