From the course: Using SQL with Python

The essential four

From the course: Using SQL with Python

Start my 1-month free trial Buy for my team

The essential four

“

- [Instructor] The four essential functions of a database system are create, read, update, and delete. The scatological acronym is intended to be pronounced C.R.U.D. These four functions translate to the SQL statements; insert, select, update, and delete. The Python DB-API was designed to provide a uniform interface for as many database systems as possible and has all the functionality necessary to take full advantage of most any relational database management system, but most of the time, all you need is a simple way to issue SQL statements, and sometimes, it makes sense to have an interface more closely tailored to a given application. In this chapter, we will create a Python module that acts as a wrapper to the DBA-API interface to provide a simpler, more useful SQL interface, as well as a C.R.U.D. interface.

Contents