Python Forum
[PyQt] New To Python need to develop windows Desktop Database Apps
Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[PyQt] New To Python need to develop windows Desktop Database Apps
#1
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??
Reply
#2
One option is SQLAlchemy
The other is the built-in module sqlite3
"As they say in Mexico 'dosvidaniya'. That makes two vidaniyas."
https://freedns.afraid.org
Reply
#3
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
Reply
#4
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.
Reply
#5
You can create the forms dynamically using loops
"As they say in Mexico 'dosvidaniya'. That makes two vidaniyas."
https://freedns.afraid.org
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  [PyQt] Python Desktop GUI (part 2) panofish 1 1,111 Aug-16-2022, 09:38 AM
Last Post: Axel_Erfurt
  [PyQt] How to Copy-Paste a table from Office apps to QTableView? Vittorio 5 7,132 Aug-05-2021, 11:14 AM
Last Post: Axel_Erfurt
  video player inside a frame/panel in python raspberry pi desktop application MATHEWS 1 2,812 Dec-12-2018, 11:42 AM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020