How to properly organize the work of the database in a QT/PyQT application?

Question

SQL

Good afternoon! I'm new to QT, in fact, there is a desire to write an application - where I will maintain a database with the addition of new rows through the interface and keep automatic statistics on changes to this database - how to properly organize the work of the database? and in general is it worth doing or is it just qtableview?
Initially I thought to make sqlite - but then I found out that you can use qtableview and use the standard form for tables itself - how would it be easier? Is it possible to save changes with standard commands or will I have to make commits? I look forward to your suggestions on architecture :)

Answer 1

To work with the database, there is QSqlDatabase. Examples and documentation on the official Qt website.