hi , could postgres NOTIFY be better/simpler than having to install tornado to have socket message to my app?
No, PostgreSQL NOTIFY will send notifications to a process on the server. You still need a way to then push that notification to the browser. In the post linked above, node.js is playing the role that Tornado plays in web2py's websocket_messaging feature.