SQLite configuration file

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!

Advertisement