This directory contains SQLite database examples and demonstrations.

• demo.py - Python demonstration script
• favorites.py - Example working with favorites data
• favorites.csv - Sample CSV data
• favorites.db - SQLite database file
• shows.db - SQLite database with shows data
• readme.txt - Additional notes

python demo.py
# or
python favorites.py

sqlite3 favorites.db

Then you can run SQL commands:

.tables
SELECT * FROM favorites;

• SQLite Documentation
• SQLite Tutorial
• Python sqlite3 Module

• .tables - List all tables
• .schema - Show database schema
• .mode column - Set column display mode
• .headers on - Show column headers
• .quit - Exit SQLite