You are here

MySQL

For the course "Current trends in HCI" ("Actuele trends in HCI" in Dutch), I followed at the UHasselt, we had to create something around a theme. This year the theme was "Shopping". Yannick and I wanted to get rid of all the different loyalty cards we had and replace it by a simple alternative that could replace them all.

We created an Android application called LoyaltyWallet. It keeps track of your loyalty cards and allows you to bring just your phone instead of 500 different loyalty cards. You can manage (add and delete), share and use the cards easily. Loyalty cards can also be shared with you, this allows you to share one card with everyone in your dorm without the need to pass a physical card around. When you are in an unknown environment and need to find a store you have a loyalty card of, the app tells you where to go.

Stores can gain crucial insight by asking the user to fill in surveys. By answering the survey, the user gains extra points or discounts. When there are new surveys or pending shares the app notifies you, so you never have to miss a reward or sharing offer....

This tutorial explains how to create the MySQL driver for Qt5 on Windows using MinGW. If you are looking for the tutorial to do this with Qt4, click here.

Step 1

Download all the needed software.

Qt (libraries and source code)
This are two separate files! E.g. qt-windows-opensource-5.0.1-mingw47_32-x86-offline.exe and qt-everywhere-opensource-src-5.0.1.zip

MySQL Community Server (E.g. mysql-5.5.30-win32.msi)
I didn't use version 5.6 because the .msi only allowed me to install the 64-bit version of the Client C API Library, which apparently gives errors later in the tutorial. So make sure you get the 32-bit verison! If you really want version 5.6, an option might be to download the 32-bit version of the source files and use those. Note that I didn't test this option, so I can't help you with that.

As you might have seen I'm working on the E-Sheet project of the Royal Belgian Ice Hockey Federation (RBIHF). This project is created with Qt on a Windows system and requires a connection to a MySQL database. Since Qt doesn't deliver the MySQL driver by default, I had to created it myself. You can recognize the problem from the following error: Driver not loaded.

I checked out several tutorials but they were either unsuccessful or extremely slow or even both. The main reason they were unsuccessful is that they aren't compatible with the new Qt versions (4.7.x and up). I listed a few of them below:

Qt Documentation
This one should work, but will take a lot of time, since you have to compile Qt. Another problem was that while configuring Qt the following error occurred: Perl not found