I just created a simple configuration file for SQLite. It’s in my home directory, and is called
.sqliterc. It contains the following lines:
# SQLite configuration file
.echo ON # repeat every command
.header ON # print column names
.separator “t” # change default separator to tab
.nullvalue “Null” # print the word “Null” rather than having empty fields
Now, every time I start SQLite, these commands will be run.
* Thanks to Kurt, who showed me how to do this!