Python can connect to a wide variety of databases using the various integration technologies we’ve studied. Once you’ve made a connection, Python’s lists and dictionaries make data manipulation simple and compact, and its object model makes it easy to build object layers on top of databases.
We begin by surveying the various libraries available for connecting to a relational database and executing queries. In the second half of the chapter, we build some sample applications that demonstrate Python’s abilities to manipulate data in sophisticated ways. We presume a knowledge of basic SQL and familiarity with the concepts of relational databases.