Python Apps with SQLite

0% of 3 hours and 48 minutes completed.

SQLite is a fast, small-footprint, zero-administration database that can be used in a broad array of circumstances. For example:

Embedded devices and the Internet of Things

Medical devices, cell phones, game consoles, cameras, kitchen appliances, and even drones.


Version control systems, financial analysis tools, media cataloging and editing suites, CAD packages, record keeping programs, and so forth.


Generally, any site that gets fewer than 100K hits/day.

Cache for enterprise data

As a cache of relevant content from an enterprise RDBMS, reduces latency because most queries now occur against the local cache and avoid a network round trip.

This course will cover connecting to a SQLite database and querying its tables. It will also delve into inserting, updating, and deleting rows. Plus, it provides a thorough examination of PRAGMA, a mechanism for getting or setting SQLite environment variables.

Support for interfacing with SQLite is provided by sqlite3, available in the Python Standard Library. The course will explore open-source third party packages, available from PyPI or GitHub, that provide additional functionality.

After completing this course, you will be able to:

  • Connect to an SQLite database and retrieve data by executing a query.
  • Execute SQL statements that modify the contents of a table.
  • Work with alternative SQLite wrappers: apsw and records.
  • Examine PRAGMA and use it to get or set SQLite environment variables.
  • Use PRAGMA to obtain table information.
There are no resources available.
0 attachments
SQLite: Retrieve data
1 hour 12 minutes 12 Activities: Article  (4)  |  Lab  (3)  |  Video  (5)
SQLite: Insert, update, and delete
1 hour 8 minutes 8 Activities: Article  (2)  |  Lab  (3)  |  Video  (3)
SQLite: Other considerations
1 hour 22 minutes 9 Activities: Article  (2)  |  Lab  (3)  |  Video  (4)
1 minute 1 Activity: Article  (1)  |  Lab  (0)  |  Video  (0)
5 minutes 1 Activity: Article  (1)  |  Lab  (0)  |  Video  (0)