I am working on building a dashboard/ interactive web application that pulls from a database to show the data in the form of interactive graphs, models that can change overtime. The data I'm using is in PostgreSQL/ pgAdmin. This is an internship project.
I believe I should be writing SQL commands to access the data, but I'm reading that hardcoding SQL logic is a bad idea in the event that the database scheme were to change, etc. So you're supposed to use an Object Relational Mapper. I'm quite confused about what to use. Do I need to use python and then connect the client and server side with Node.js? I saw a recommendation for that, but I don't understand how.
Overall, this is my main question. Can someone tell me all the components I need to build this web application that pulls from a database and displays graphs? Also any recommendations for languages frameworks that would help?