Chapter 18. Database Programming

Chapter 18. Database Programming
	Part I. Design Patterns and Qt

Table of Contents

18.1. QSqlDatabase: Connecting to SQL from Qt
18.2. Queries and Result Sets
18.3. Database Models
18.4. Review Questions

[ fromfile: database.xml id: database ]

Abstract

This chapter gives a general introduction to the capabilities of Qt's SQL classes, using Sqlite as an example back-end.

Learning SQL?

Do not bother learning SQL with any book that claims to be on "standard" SQL. The best manual to read is the reference guide for your chosen database server software because each server supports slightly different syntax and data types. Fortunately, with the exception of creating tables and other DDL queries, mapping between SQL values and QVariant is made quite easy for you by the QSql API. When you have used more than one database, then you should either look for an abstraction layer (which might end up being an obstruction layer, depending on how well it is written), or write SQL for the least common denominator (SQLite).

Qt provides a platform-neutral database interface similar to JDBC.^[73]
It requires a driver for each specific database that it can connect to.
To build the driver against a specific database, the development header files of the database and also its libraries must be available.
You can use Qt to connect to a variety of different SQL databases, including Oracle, PostgreSQL, and Sybase SQL.
In the examples that follow, we have tested our code with MySQL and SQLite on Linux.

If you develop something new with QtSQL, we recommend using SQLite syntax because it:

Is open source.
Comes with Qt.
Does not require building Qt from source, or building a plugin, or setting up a standalone server.
Maps each database to a single file on disk.
Supports a subset of SQL which is available on most other systems.

	What About Other Drivers?
	For more information, see the Qt SQL drivers documentation page.

	What Drivers Are Already Supported?
	To find out which drivers are available to the current version of Qt: Run `$QTDIR/demos/sqlbrowser`, and you can see a driver list in a combobox on the initial Connection settings dialog, as shown in Figure 18.1. Call `QSqlDatabase::drivers()` from code.

Figure 18.1. Sql Browser Connection Settings Dialog

	Object-Relational Mapping Layer
	If you want to completely isolate yourself from SQL and map objects directly to persistent storage, you might be interested in Code Synthesis ODB, an open source object-relational mapping layer with support for Qt types.

^[73]Java Database Connectivity API


17.4. Review Questions		18.1. QSqlDatabase: Connecting to SQL from Qt