SQLite 3 cheatsheet
SQLite 3: Opening and leaving
6 common SQLite 3 tasks.
Print the version of the sqlite3 shell.
Open a database file, creating it if it does not exist.
Run one statement and exit.
sqlite3 app.db "SELECT COUNT(*) FROM users;"
Switch to a different database file from inside the shell.
Show every shell command.
Leave the sqlite3 shell and return to your terminal.