For about 40 years, relational databases managed with the structured query language (commonly known as SQL) have been the de facto standard technology for storing, retrieving, and analyzing the world's data. Whether you are creating business applications, games, web applications, or something else, if your application deals with a large amount of data, you will almost certainly be working with SQL. While Python has many modules available for connecting to a SQL database, Qt's QtSql module provides us with powerful and convenient classes for integrating SQL data into PyQt applications.
In this chapter, you'll learn how to build database-driven PyQt applications as we cover the following topics:
- SQL basics
- Performing SQL queries with Qt
- Using SQL with model-view widgets
