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:
[sourcecode language=”bash”]
# 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!

Leave a Reply

Your email address will not be published. Required fields are marked *