SQLite shortcuts

SQLite tips & tricks

sqlite3 sqlite_filename - Open up a SQLite file in the SQLite command-line.
.quit - Exit out of the sqlite CLI.
.schema - Show the full list of tables & indexes in the database.
.schema table_name - Show the table creation command and any index creation commands for that table.
ssh user@host 'sqlite3 ~/filename.sqlite3 "SELECT * FROM accounts WHERE acct_url LIKE '"'"'%fidelity%'"'"';"' - Externally query via SSH with some weird quoting to handle single quotes inside single-quotes.