SQLite is a file-based, serverless database that comes built into Python and dozens of other platforms. This guide covers when to use SQLite over MySQL or PostgreSQL, its real trade-offs, and how to get started with practical Python examples.