[Python] Choosing the right stack for developing an application [closed]

I am new to development, and this is my second year in this amazing world! I am currently doing an internship without a supervisor, and I need to create an application to convert and clean a file in .CSV format, and insert it into an SQL database. After the conversion, the user needs to be able to view all the information in the file and add new data. They will also need to convert this information from a new database back into a .CSV file to exchange it with others. I have created my workflow and thought about different tech stacks:

Full Python Stack: Using Flask or Django for both the back-end and front-end (though I wonder if I'll be limited in creating a good front-end? But at least I won’t have to use too many different languages). Pandas will be used for converting and cleaning the .CSV file.

Mid/Mid Stack: Flask or Django for the back-end and Angular for the front-end, using Python + TypeScript. This might be a good choice here.

Advanced Stack: Java/Spring Boot for the back-end, Python/Pandas for handling the .CSV file, and Angular for the front-end. Languages: Java, Python, TypeScript. I think this is a very solid stack for building a strong application, but for maintenance and long-term viability, it might involve too many different technologies.

For the Database: Since there are a lot of files to add to the database, I was thinking of using PostgreSQL for data that requires a relational database and Cassandra for storing all the .CSV files.

Thank you so much for your help!

Have a great day, Marina

At the moment, I'm working on my project brief and looking for information to create a good application for my work.

Continue reading...