QML with local database SQLite

[Calvev]

Hi everyone,

I'm really new with QT Quick and loving it. I'm planning to create an app that uses SQLite as local database.
However, I'm not sure how to do it. I have no problem doing it on normal QT application but since I learned about QT Quick, I prefer it over the QT application.

Could anyone point me to where I should be looking?

Thank you,

[jpnurmi]

Perhaps http://doc.qt.io/qt-5/qtquick-localstorage-qmlmodule.html is what you're looking for.

[Calvev]

I found this to be perfect:

https://wiki.qt.io/How_to_Use_a_QSqlQueryModel_in_QML

Though I'm not quite sure what certain lines do. I'll have to learn it further. But,. it is now working perfectly.

I can now read my DB. For writing into the DB, I have implemented another class of QObject and set it as property in my QML.

[benlau]

If you would like to try a ORM solution, you may take a look at :

danielfranca/quickmodel: QuickModel: ORM for Qt/Quick

[Calvev]

Thanks for the suggestion, I'll look into the ORM :)