Sqlite3 readable output

To make the sqlite3 console output more readable run:

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

This will create a file named .sqliterc in your home directory with a minimal configuration enabling table headers and setting 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