I would really appreciate some advice on how Vue.js could/should be getting and sending information to databases. I’ve been programming in other languages for many years and am trying to make the transition to the current way of developing web apps so that I can be employable in a modern IT shop.
Back in the day, we didn’t make the distinction between frontend and backend the same way it is done today and I still don’t fully understand the current way of thinking. It used to be absolutely standard for, say, a COBOL/COBOL II/PL1 program to display screens, gather data from that screen, validate it, then write it to a database like IMS or DB2. Nowadays, there seems to be something like a wall between frontend and backend and someone is either a frontend person or a backend person. In fact, I had a very experienced developer insist that there’s no such thing as a full-stack developer because you were either frontend or backend.
At the moment, I’m learning how to build frontends with Vue and that’s going okay. I’m ready to take the next step and store the data I’ve acquired (or fetch data previously stored) in a database. I’m not very clear though on what database I should use - MySQL, Firebase, MongoDB, etc. - and on how to get and write data to a database from a Vue app. I’ve worked with Vuex and Pinia a bit and am under the impression that Pinia is a more powerful Vuex. I’ve worked a very little bit with Axios and know that is one way to read or write from a database in Vue. But I don’t know if these are the best ways to do things or if there are much better ways. Unfortunately, the Vue courses I’ve found in YouTube are reluctant to spend much time on database access because it can be a long sidetrack so they typically use workarounds like JSON-Server, which even they acknowledge would never be used in real-world Vue apps in production.
I would really appreciate it if some of the people on this forum, who work in real IT shops, could share some information about the most common ways they have seen of getting Vue apps to interact with databases and what emerging approaches look like they may become very popular with time.
I need to figure out what to learn next and this information is crucial to making that decision.
Thank you in advance!