Chapter 3. Database Connection
In the previous chapter, we learned how to create a login page from scratch. However, it is not functional yet, as the login page is not connected to a database. In this chapter, you will learn how to connect your Qt application to a MySQL (or MariaDB) database that validates login credentials.
In this chapter, we will cover the following topics:
- Introducing the MySQL database system
- Setting up the MySQL database
- SQL commands
- Database connection in Qt
- Functional login page
We will walk through this chapter in a step-by-step approach to discover the powerful features that come with Qt and allow your application to connect directly to a database without any additional third-party dependencies. Database querying is a huge topic by itself, but we will be able to learn the most basic commands from scratch through examples and practical methods.
Qt supports multiple different types of database systems:
- MySQL (or MariaDB)
- SQLite (version 2 and 3)
- IBM DB2
- Oracle
- ODBC
- PostgreSQL
- Sybase...
