Home

SQLite Python tutorial

The e-book has 171 pages. It has 91 code examples. It covers database programming with Python and SQLite in great detail. It is an ideal material for those who already know some basics of database systems and the Python language. Carefully chosen examples always focus on one important aspect. (Unless it is a more complex example.) Buying this e-book you will save a lot of hours searching on the Internet, asking on forums and figuring things on your own. What took the author months and weeks to find out, you will get in days and hours. The e-book is written in plain English.

The code examples were tested on Linux and Windows. Python 2.7 and SQLite 3.6.21 on Windows XP. Python 2.7.5 and SQLite 3.7.17 on Windows 7. Python 2.7.2 and SQLite 3.7.7 on Linux. After purchasing the e-book, you will be redirected to a page, where you can download a ZIP file. With the PDF file, you will also obtain all code examples.

If something goes wrong with the payment process, drop me an email at vronskij(at)gmail.com.

Price

The e-book costs 14.5 €.

Other payment options

EU citizens can purchase the e-book via wire transfer without additional fees. If you would like to use this payment option, contact me at vronskij(at)gmail.com and I will send you the details.

About this tutorial

This is SQLite Python e-book. This e-book is a tutorial, which teaches database programming with SQLite database and Python language. It is an in-depth e-book, which covers many areas in great detail.

This e-book covers the following:

The first chapter presents a quick overview of important terms and concepts related to our field. In the second chapter, we cover all the methods used for executing SQL statements. We show how to properly execute SQL statements to avoid SQL injections.

The Data types chapter examines the dynamic type system of the SQLite database. We describe the data types of the SQLite database and the conversion between them and the types of the Python language. The next chapter shows various ways of reading data from the database.

The fifth chapter covers foreign keys in the SQLite database. In the Date & time chapter, we have 16 examples dealing with date & time. We cover the ISO-8601 format, Unix time or Julian date among others.

In the Custom functions chapter, we have examples for normal and aggregate custom functions. The Collation chapter deals with ordering and sorting of characters. We mention the SQLite's limitations in this area and show how to create our custom collations.

In the Binary data chapter, we work with images. We show how to insert and read an image. The Metadata chapter has multiple examples for dealing with metadata in SQLite.

The Authorization chapter focuses on the authorization process available in SQLite. The Transactions chapter provides several code examples with transaction support.

The SQLAlchemy chapter gives a brief but sufficient introduction to the SQLAlchemy Object-relational mapper. The chapter has 16 code examples. The last chapter is dedicated to QtSql module of the Pyside toolkit. 10 code examples detail various classes of the module.

Screenshots

The following two screenshots are from the last chapter, which deals with the QtSql module of the PySide toolkit.

Read-only model Relational model