SQLite3 CLI commands
| Code Block | Code Desc |
|---|---|
sqlite3 <db>
|
Start new or connect to existing db |
SELECT * FROM x_table;
|
Use raw SQL commands |
.help
|
List dot commands |
.tables
|
Return list of tables in db |
Ctrl-D
|
Exit CLI |
PRAGMA table_info(<table>);
|
Returns column names and types |
I'm sure that there are good things that can be done with the SQLite CLI, but honestly feels like too little. There's better tools to use like SQLAlchemy or working with data using the Django shell.