Use a Configuration File

You can create a file to set your defaults for the SQLite client in $HOME/.sqliterc

Example:

.headers on
.mode box

Resources and References

• StackOverflow: “Change SQLite default settings”