First of all, PHP has no event loop: it was designed to receive input, do some work, then return the results. It implements a concept called "shared-nothing architecture" which means a script doesn't share anything with another script. Implementing a "loop forever" script in PHP means overriding so many settings that no out-of-the-box host will want to touch your scripts.
This, among many other things, means a direct construct-to-php conversion will never work.
It would be great if somebody can make a plugin around node.js to support communication to mysql. I think it should go well because it is javascript?
It is possible to create a plugin to save construct2 things to MySQL, and then create a companion php script that you can run on a webserver, but if you're going to do that, you might as well make a company that provides this as a service.
Also, unfortunately, the store still doesn't accept plugins as submissions...
Actually I won't consider PHP as a good language as it has some quirks that should be fixed since years ago. That's why I've switched to Node.js as my main server-side backend recently because of it's simplicity and language (no more PHP )
Everything you said is true (Nothing beats PHP in terms of speed of development, though!)
Also, I'd argue that the main advantage of moving to Node.js is increasing code reuse, since you can start coding in javascript and never leave.
Btw, if the code to communicate with mysql is on the client side, that would be security issue right?
Yes, but if you get someone to develop this for you, they won't do it like that.
Besides, if you don't know server-side programming, you probably don't know SQL either.
There are many ways to guarantee security while keeping code on the client.
Noob Findings: NoFlo
Will this tool allow me to achieve what I need? It mentioned node.js in the overview.
No, it won't.
But it's a very nice tool, thanks for posting it!