If you are in a sqlite shell and forgot to change directory or want to navigate to a separate directory, you can do that with the .cd dot command.
.cd /path/to/directory
This is better than doing .shell cd /path/to/directory because it doesn’t open a separate terminal process. So, the .cd is persistant throughout the session, whereas the .shell cd <path> will only within that command (subprocess).
If you are in middle of a sqlite shell session, and you don’t want to quit the shell to run arbitrary shell command, you can simply use the .shell <command> to execute any shell commands right from within the sqlite shell. How handy is this!
.shell echo "hello, world!"
That is a lame example, but it shows you the power of the .shell command.
Let’s say I want to run a golang project, I can do this:
Explorng SQLite CLI with inline CSV import command with custom separator