Disclaimer: I'm not a programmer, just a SQL guy. Forgive me if my question(s) and/or responses frustrate.
I'm hoping there is a currently existing solution out there someone could point me to. I am looking for an open-source solution for form-data that uses a SQL backend. This is a potential project I think could work for my employer. Basically, all I need is a GUI interface that communicates with a SQL DB (we currently use MSSQL, but can use MySQL if need be) for basic form data. The GUI would need to have read/write ability to DB, and by the same token, edits made to DB directly (via TSQL statements) would need to reflect in GUI. GUI would ideally contain functionality for uploading/retrieving files (text/image/pdf), also from SQL. I would love a Python-based solution (as that is the language I have interest in learning), but whatever open-source solution there is will work. Obviously, open-source is needed as I will need to tailor the program to my needs. Also, I am not looking for a web-based solution. I want a local application that is fed by the DB, which would provide the inter-connectivity. I hope I'm using the right terminology to convey what I'm seeking.
Big thanks in advance!
*requirements: basically, all I'm looking to do is have a window that has editable fields, and other windows that hold relationships based on a unique identifier. For example, this is all based on a person's name. when searched/selected, the initial window will hold vital info (name, address, dob, etc.) but there will be buttons/links to other windows that hold other data such as organizations they belong to, or another button to show a window that contains what products they have purchased. All this data is stored in SQL. This is only to be a desktop application that interfaces with SQL. I hope this clarifies what I'm after.