Most databases are organized using relational models. A relational database consists of one or more related tables of information, and the relationship between information in different tables is described using keys. Conventionally, these databases are managed using the Database Management System (DBMS), software which interacts with end users, different applications, and the database itself to capture and analyze data. Commercially available DBMSes use Structured Query Language (SQL) to access and manipulate databases. We can also use Python to access relational databases. In this section, we will explore SQLite and MySQL, two very popular database engines that work with Python.
According to the SQLite home page (https://sqlite.org/index.html), SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain SQL database engine.
SQLite is optimized for use in embedded applications. It is simple to use and quite fast. We need to use the...