Qt5 Python GUI Programming Cookbook

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