How to Store and Retrieve an Image or File with SQLite
Images or any files can be stored in a database. Here is one way to do it using the following steps:
1. Read the system file into a QByteArray.
2. Store QByteArray as a Binary Large Object in database.
For example :
- QSqlQuery query;
- query.prepare("INSERT INTO imgtable (imgdata) VALUES (?)");
- query.addBindValue(byteArray);
- query.exec();
Now, the image/file can be retrieved like any other data
- query.next();
Creating a QPixmap from QByteArray :
It is done. Now the pixmap can be used in a Button as icon or in label etc.
