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...