Jan-27-2020, 04:49 PM
Unless your current db is tiny I would just use pyodbc. You can use your old queries and stored procedures for now and upgrade to an ORM like SQLAlchemy later.
Tkinter is built-in and may look like Win95 but it's the shortest path to a GUI despite its lack of documentation. All of the packages you mentioned will take some time to learn and can be frustrating if you're used to VBA's drag and drop WYSIWYG environments. If you know any HTML/CSS also consider a web-based app with Django, Flask, Dash, etc.
Tkinter is built-in and may look like Win95 but it's the shortest path to a GUI despite its lack of documentation. All of the packages you mentioned will take some time to learn and can be frustrating if you're used to VBA's drag and drop WYSIWYG environments. If you know any HTML/CSS also consider a web-based app with Django, Flask, Dash, etc.
"So, brave knights, if you do doubt your courage or your strength, come no further, for death awaits you all with nasty, big, pointy teeth!" - Tim the Enchanter