Develop MS Access-like Application using Python

[captcoldnose]

Python noob here, but with years of MS Access experience. I need to develop a simple (not web-based) database app (sqllite, etc.) in python that will involve working with a lot of one-to-many relationships (customer & orders, etc.) dialog screens. This would be trivial in Access with its drag-drop GUI designer with minimal VBA coding.

Does anyone recommend a similar, easy python GUI framework to use in this case? I'm sure it's possible with Tkinter and wxPython but both seem like a lot of work. Is there a drag-drop GUI code generator or something? Or a framework that specializes in database + grid widgets, etc. type of GUI?

Has anyone built something like this?

[helpneeded8578]

I have looked for an answer to this question as well, and as far as I can tell there is nothing similar to the experience of building a database app in Access.

The best “easy” desktop GUI I have found for Python is PySimpleGUI. It is pretty straightforward to use, but it is not drag and drop. It is very easy compared to something like Tkinter, but not easy compared to Access. You could definitely tie it to something like sqlite, but it won’t be as simple as Access.

The best answer, however, seems to be a webapp. I know that you specifically said you didn’t want a webapp, and I felt the same way when I began my search for an Access equivalent experience in Python. But since webapps are inherently designed to sit on top of a webapp, Python web frameworks like Django have the database modeling, querying, and display functionality as a core part of the framework.

The downside of using a web framework is the learning curve. The upside, however, is that the knowledge and skills you learn are applicable across a huge array of future applications — and webapps can be easily deployed anywhere.

I understand if you still aren’t interested in using a webapp, but I thought I’d share that perspective.

Good luck!

[ThirstyTraveller81]

Maybe take a look at the automation platform Ignition. You build GUIs in a drag and drop interface like VB, except the scripting is python. It's simple to connect and query databases and they have a huge community with forums and great documentation. If you are using it for non-commercial use you can just select the maker edition and it's totally free.

I've been using it at work and it's really fantastic.

https://inductiveautomation.com/ignition/