Python Apps with SQLite
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.