Python SQLite

Python SQLite3 module is used to integrate the SQLite database with Python. It is a standardized Python DBI API 2.0 and provides a straightforward and simple-to-use interface for interacting with SQLite databases. There is no need to install this module separately as it comes along with Python after the 2.5x version.

This Python SQLite tutorial will help to learn how to use SQLite3 with Python from basics to advance with the help of good and well-explained examples and also contains Exercises for honing your skills.

Introduction

• Introduction to SQLite in Python
• Python SQLite – Connecting to Database
• SQLite Datatypes and its Corresponding Python Types

SQLite Queries

• Python SQLite – Cursor Object
• Python SQLite – Create Table
• Python SQLite – Insert Data
• Python SQLite – Select Data from Table
• Python SQLite – WHERE Clause
• Python SQLite – ORDER BY Clause
• Python SQLite – LIMIT Clause
• Python SQLite – JOIN Clause
• Python SQLite – Deleting Data in Table
• Python SQLite – DROP Table
• Python SQLite – Update Data
• Python SQLite – Update Specific Column

Working with Tables

• Check if Table Exists in SQLite using Python
• How to list tables using SQLite3 in Python ?
• How to Alter a SQLite Table using Python ?
• How to Delete a Specific Row from SQLite Table using Python ?
• How to Update all the Values of a Specific Column of SQLite Table using Python ?

Working with Images

• How to Insert Image in SQLite using Python?
• How to Read Image in SQLite using Python?
• Storing OpenCV Image in SQLite3 with Python

Exercises

• Count total number of changes made after connecting SQLite to Python
• How to Show all Columns in the SQLite Database using Python ?
• How to Count the Number of Rows of a Given SQLite Table using Python?
• How to import CSV file in SQLite database using Python ?
• How to Execute a Script in SQLite using Python?
• How to store Python functions in a Sqlite table?
• How to Create a Backup of a SQLite Database using Python?
• How to connect to SQLite database that resides in the memory using Python ?
• Change SQLite Connection Timeout using Python