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

Examples

Query data and place in file

sqlite3 data.db <<EOF
.headers on
.mode csv
.output output.csv
SELECT profile_picture FROM users where profile_picture is not null;
.output stdout
EOF