On Wed, 16 Jun 2021, Alan Gauld via Python-list wrote:
But there is nothing I know of for Tkinter that provides views of database tables in the way that Delphi or VB or C# do, for example.
Alan, These are all Microsoft tools. I run linux only.
You have to extract the data using SQL and populate the table and manage all changes (of both view and data) yourself.
From an incomplete reading of the tksheet() doc it looks to be the best way
to display tables returned by a SQL query. PyQt5 has a QTableView() that does the job, and it works great for a single table, but apparently not so well with complex joins on multiple tables. When I view my contacts table it needs to includes attributes from the company, people, and contacts tables so I can view all prior contacts with that person.
If you do a lot of that kind of desktop apps then you could look at Dabo which is built on wxPython but has links to databases. Unfortunately it looks like work ground to a halt about 5 years ago.
Many years ago I used wxPython. For several reasons I decided to learn and use tkinter from now one. One reason is that the application for my clients will run mostly on windows hosts and I want to limit the software they need to install and maintain in order to run it. Regards, Rich -- https://mail.python.org/mailman/listinfo/python-list
