Introduction

SQLite is a very easy-to-use database engine. Basically, it is a lightweight database meant to be used in small applications that can be stored in a single disk file. It is a very popular database used in phones, tablets, small appliances, and instruments. SQLite does not require a separate server process, and does not even require any configuration.

To make this database easy to use in Python scripts, the Python Standard Library includes a module called sqlite3. So, to use SQLite in any Python application, you need to import the sqlite3 module using the import statement shown here:

import sqlite3

The first step to use any database is to create a connect object, by means of which you need to establish a connection with the database. The following example establishes a connection to the ECommerce database:

conn = sqlite3.connect('ECommerce.db')

This example will establish a connection to the ECommerce database if it already exists. If the database does not already exist, the database...