✂️ SQLite

(most recent on top)

Quick survival guide for exploring a new database

• Command Line Shell For SQLite - 5. Changing Output Formats
• Command Line Shell For SQLite - 6. Querying the database schema

.headers on
.mode column
.tables
.schema

select * from table limit 10;

See the CLI command history

• SQLite CLI command history
  • ↑ and ↓ — recall last commands
  • Ctrl+R — search command history HF: Not working?

cat ~/.sqlite_history