Lulu Press, Inc, 2021. — 54 p. — ISBN: 978-1-716-24602-9.
This book provides an alternative approach to building Python applications with SQLite databases. 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 databases.
I use Sqlite 3 for the 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 on your platform. For Windows, you can download SQLite-tools.
To access SQLite from Python, we need an SQLite driver for Python. Fortunately, the SQLite driver for Python is already included in Python standard library so we don't need to install this.
Technically, you can use any editor to develop Python. For the demo, I use Visual Studio Code to write 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.