I have a little python and java (school) experience under my belt, but nothing professional or complete. I am trying to create a small database using MySQL, which I think I already figured out. I am using Python to build functions that let me edit the database and pull information from it. That too I have already figured out how to do. The last problem is creating something for users to interface with so that they too can edit the database.

The db will be on my own server, I think I can run a full python app from the server. But I was thinking of a web browser interface so users can just go to a web page rather than having to run a .exe or whatever.

From reading, I see suggestions of using Flask. Is that generally correct? I'll have my SQL db, python app(s) going back and forth with each other. And then Flask going back and forth between python and HTML/CSS? Really I just need to have access to html forms that send data to a python function that modifies the db. Or is using just a plain python GUI okay? It would certainly cut down on trying to brush up on my html, css, and javascript.

My brain is just kind of overloaded right now and any help would be appreciated.

  • steve5487 [none/use name]
    ·
    3 years ago

    I worked on a project that used flask for a web based SQL using html a couple of years ago. As I recall Flask worked well for using the database and was a big help. I'd be willing to help if you want but I warn you the last time I did something like this was a couple years ago so I might not be that much help

    • mr_world [they/them]
      ·
      3 years ago

      Thanks for the offer but this is work-related and there's no sense in anyone but me doing labor on this. My job is a full time job but it's not a full time work, I have some spare time. I'm trying to relearn some programming stuff for my own enrichment and to help out me and my coworkers. A database is sorely needed because we're running purchasing, quality control, and inventory almost completely on spreadsheets. The rest is locked behind some 1995-ass commercial software specific to the industry that costs thousands per month to use. I'm not trying to replace that, just supplement it so we can stop having to do spreadsheets by hand.

      I'm not even getting paid extra to do this, just trying to fill my spare time with a project. I'm doing the capitalist thing of hoping I'll get some "skills" that I can parley into a raise or a better position. Probably won't though. We'll just use it while I'm here, I won't get paid any extra for it, and they'll stop using it when I move on to a different job. In that case at least I will have a deep refresher on programming which I can use on a personal project.