What software to use?

[pickledrick]

Hi
I have built a fully functioning global supply chain management system in google sheets.

I want to turn this into an online webapp where I can log in and up load the data and for the online system to mimic my google sheets system.

I will need to up load CSV file, those CSV files be cleaned and processed before being added to the database.

Then i need to perform calculations of the data and drop those results in other tables then view the tables in the online webapp.

I would also like to be able to input changes on the webapp and the database recalculate and show the updated results.

Can anyone advise the best group of languages (mysql, django or flask, php, etc etc) that I will need to know to create and finish the whole project?

Thanks in advance

Rocky

[jefsummers]

You've got a good start. MySQL is well established, supported (community), and relatively secure. Without knowing your details, might also look at Mongo DB if you want to consider a different structure. Python does indeed make a great back end. Flask can work, Django is fuller featured, but I would try FastAPI for the interface. Read about it HERE. A basic knowledge of HTML/CSS/JavaScript may also be helpful. Just my oopinion.

[pickledrick]

You've got a good start. MySQL is well established, supported (community), and relatively secure. Without knowing your details, might also look at Mongo DB if you want to consider a different structure. Python does indeed make a great back end. Flask can work, Django is fuller featured, but I would try FastAPI for the interface. Read about it HERE. A basic knowledge of HTML/CSS/JavaScript may also be helpful. Just my oopinion.

Thanks Jeff, really appreciate your insight.

Ok so i go with Python as the back end, use MySQL for the database section and then use FASTAPI for the front end - just checked out the FastAPI link you sent me and looks like it is purpose built for Python which is good.

So i guess I start off my journey with Python, down the rabbit hole i go

[mojobadshah]

I used Django for the backend because it has built-in database management and makes it easy to create RESTful APIs. For the frontend, I went with React. MySQL was my choice for the database, as it’s reliable and scales well.

In my case, the CSV upload and cleaning process needed automation, so Django's model architecture helped with that. I also set up API endpoints for easy communication between the frontend and backend.

I also wondered how to create software from scratch, especially when you're used to working with spreadsheets. The trick is to break down the process into smaller tasks—data handling, business logic, and user interface.