How should I use Qt SQL classes to support BLOBs?
-
I'm using SQLite and where possible using the higher level classes (QTableView, QSqlRelationalTableModel, etc) to view and update table data.
I'd appreciate any general guidance folk can provide on how best to support BLOBs. I'd like to load the BLOB (eg image, video, audio track) from a file, display an appropriate icon in the table view, save the BLOB to the database table, and of course retrieve the BLOB from the database via the tale view.
-
According to the docs it's supported:
"SQL Database Drivers":http://doc.qt.nokia.com/stable/sql-driver.html
"QSqlDriver Class Reference":http://doc.qt.nokia.com/stable/qsqldriver.html
"Data Types for Qt-supported Database Systems":http://doc.qt.nokia.com/stable/sql-types.html