Should I use NodeJS with PostreSQL or stay with Yii2 + PostreSQL?

Question

JavaScript

Good afternoon community!
Here the task arose of choosing a new technology for a serious product. Before that, everyone wrote in Yii2 + Mysql. Switched to PostreSQL because of a bunch of goodies. All stored data is relational.
Now I am looking at NodeJS very seriously, I like its asynchrony and it has been stable for a long time. The whole project is mostly Backend API + Frontend.
Does it make sense to use a bunch of NodeJS + PostreSQL (convenient / inconvenient, productive / unproductive) or is it Yii2 + PostreSQL?

Answer 1

on a node it will be more difficult (and develop and maintain) and longer (2 times longer for development and one and a half times more for support, time is money), but there will be such goodies as a runtime application with all the consequences (speed for the most part, well, the convenience of using a web socket, if any).
if there is a desire to write an enterprise application in order to work ironically, then yii, if you just need to learn a new technology, then a node.

Answer 2

IMHO, the question is put incorrectly.
Who will code? If he has sufficient experience with {YII|NodeJS|*}, he will give low risks and an acceptable cost (in terms of time and money). And vice versa.

Answer 3

If the question is exactly how to use PostgreSQL with a node, then there are no problems - there is sequelize , waterline and, I think, many more modules for convenient work with the database and ORM. In terms of speed, the gain will also most likely. Well, otherwise there are too many "buts" and "ifs" to be able to unequivocally say whether it is worth doing or not.

Answer 4

It makes sense to use what is easier for you to work with. If you look towards nodejs, pay attention to LoopBack , the back-end api will more than cover, extensive documentation and convenient testing / administration tools, plus it works great with various databases.
We use it to form and synchronize presentations with a total simultaneous load of up to 220k uniques. He does his job very well.
There are analogues of projects on Zend+PostgreSQL and Laravel+PostgreSQL, but the performance of the node is higher.

Answer 5

Definitely Postgres is better than mysql. About nodejs and yii2, I can only say that most likely nodejs is faster than php and development on it is more convenient (for example, I was always surprised by the need to keep a special daemon next to php to manage the pool of connections to the database). php is the last century, switch to modern technologies!