SQLite3 Readable Output

To make the SQLite3 console output more readable, execute the following command:

1
(echo ".header ON" && echo ".mode column") > ~/.sqliterc

This will create a file named .sqliterc in your home directory, configuring it to enable table headers and set the output mode to column.

Before:

1
2
3
sqlite> SELECT users.first_name, users.last_name FROM users;
John|Doe
Richard|Roe

After:

1
2
3
4
5
sqlite> SELECT users.first_name, users.last_name FROM users;
first_name  last_name
----------  ----------
John        Doe
Richard     Roe

Next: Android Experiments: Hashire Hamusuta Post-Mortem