Kurniawan A. Python and SQLite Development 2021

Textbook in PDF format

This book provides alternative approach to build Python application with SQLite database. This book describes how to work with Python 3 and SQLite and illustrates their use with code examples.
Python is an interpreted, object-oriented, high-level programming language with dynamic semantics. In this book, we focus on learning how to develop Python programs to access SQLite database.
I use Sqlite 3 for demo. SQLite provides a shell so you can perform data manipulation. You can download Sqlite 3 shell on this site on Download SQLite shell based your platform. For Windows, you can download sqlite-tools.
To access SQLite from Python, we need SQLite driver for Python. Fortunately, SQLite driver for Python is already inclued in Python standard library so we don't need to install this.
Technically, you can use any editor to develop Python. For demo, I use Visual Studio Code fo writing Python scripts. This tool is free, You can download it for Windows, macOS and Linux.
The book covers database programming for SQLite with the following highlight topics:
* Setting up Development Environment
* Setting Started - Python and SQLite
* SQLite Shell
* CRUD (Create, Read, Update, Delete) Operations
* Working with Image and Blob Data
* Transaction
* Python, SQLite and Pandas