What technologies and tools to choose for web service development?

Question

MySQL

I am new to web development. I want to create for myself a web service for accounting for personal finances (yes, yes, there are a million of them :)) while simultaneously studying web programming.
The idea is this: the service can be used in a browser (SPA) and in a mobile application (iOS / Android), respectively, all data is stored on the server.
To create a SPA, I settled on Angular 2. But for the server side and the database, the question is:
1) First I wanted to make a RESTful API based on Yii2 on the server and store everything in the MySQL database
2) Now I am considering Node.js and MongoDB as an alternative
3) Also, the question is how to connect the client and server http (1.1/2) or websocket
Of course, I understand that in general it is possible to implement this way and that, and all this is possible only a matter of taste.
But I would like to hear the opinion of experienced people, which combinations of these tools are more productive from your point of view?
Thank you.

Answer 1

Do what you know best. In my opinion, both will be fine if done right.
Node or php is an old song. There are many disputes, except for anger and ignorance, there is nothing in them. Both technologies are good in their own way. Rather a matter of taste. I'm allergic to node, but there are a bunch of people with the same symptoms as php.

how to bind client and server http(1.1/2) or websocket

I think it's worth connecting via http and websocket where necessary.

Answer 2

But I would like to hear the opinion of experienced people, which combinations of these tools are more productive from your point of view?

both are quite usable, but to say something more definite, you need to know the details of the project.
if one was undoubtedly better than the other, then the second would very quickly disappear.

Answer 3

You, IMHO, are starting from the wrong place ... I would start with minimal architecture design, because the question is HOW TO IMPLEMENT? all the tools and technologies you described answer, but the question WHAT TO IMPLEMENT? You must first answer. And then you can already choose on which technology stack to implement it.