SQLite

Clients

• sqlite3 - terminal
• SQLite db browser - gui

Commands

• sqlite3 <db-name> - open database
• .tables - show tables
• PRAGMA table_info(table_name); - get table info