SQLite is a fast, small-footprint, zero-administration database that can be used in a broad array of circumstances. The fundamentals of using SQLite include knowing how to programmatically execute SQL queries and whether to retrieve data or modify the database by inserting, updating, or deleting rows. In this course, we will explore two alternative packages to interface with SQLite: apsw and records. We will also look at ways to view or modify characteristics of SQLite itself through PRAGMA statements.
- A basic understanding of the Python language and standard library
- A fundamental understanding of relational databases and Standard Query Language (SQL)