12. Database Programming

For most software developers the term database is usually taken to mean an RDBMS (Relational Database Management System). These systems use tables (spreadsheet-like grids) with rows equating to records and columns equating to fields. The tables and the data they hold are created and manipulated using statements written in SQL (Structured Query Language). Python provides an API (Application Programming Interface) for working with SQL databases and it is normally distributed with the SQLite 3 database as standard.

Another kind of database is a DBM (Database Manager) that stores any number of key–value items. Python’s standard library comes with interfaces to several DBMs, including some ...

Get Programming in Python 3: A Complete Introduction to the Python Language, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.