Python Forum

Full Version: New To Python need to develop windows Desktop Database Apps
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have a solid background in Microsoft Access Desktop Database Apps development and I need to switch my work to Python.
I learned the language and installed QT designer, I also created a sample database in SQLite3 using SQLiteStudio.
But, I cannot found a way to connect my database to the Windows created in QT (like setting the Control source property of a form in MS Access)

Is there any any way in python to connect my created window to a database table and display its records like Access does??
One option is SQLAlchemy
The other is the built-in module sqlite3
I have just created sqlite database. But I am talking about is there data aware widgets in QT5 that can display, edit or delete data from a Table in a database without explicit coding?

Thanks for your reply
see: http://doc.qt.io/qt-5/sql-forms.html
The article is about forms, but forms are made from widgets,
so I am assuming you'll get something from this.
You can create the forms dynamically using loops