How to display sqlite data as table view?

Binary Soft

Hello,
I've a sqlite db with movie data. Movie table has these field names:
ID, Cover, Name, Quality, Year. All movie picture are inserted Cover Field as BLOB.
I want to show movie cover picture with Name, Quality, Year in each cell of the table. (eg. Table with 7 Column Pictures and many rows from db.) Please see the picture below. Which model view is suitable for this view. QTableView? or Others. Any reference or examples?

When I do my customized QLabel with QScrollArea, data loading time is too slow for large records. So I want to use it as model view.

Thanks.

dheerendra

Did you get a chance to look at QSqlTableModel ? This will help you. Also look at how to write the custom delegates. So combination of QTableVeiw, custom delegates and QSqlTableModel will help you to make your concept.

Binary Soft

@dheerendra said in How to display sqlite data as table view?:

QSqlTableModel

Thanks for your suggestion.

mrjj

Hi
For delegate, please see this
http://doc.qt.io/qt-5/qtwidgets-itemviews-stardelegate-example.html

for your case, you could display the image and draw text also.
Here it paints stars but the concept is the same.

Also for ListView, check out the iconMode
http://doc.qt.io/qt-5/qlistview.html#viewMode-prop
it will layout the list like the your image.

Binary Soft

@mrjj
Thanks.