On Page Refresh database changes not affecting the view.

[dhvanipurohit]

Hey,

Thanks for this example but when i am refreshing the page after completed some add or delete event it is not showing in the screen. I mean every time i needed to close and open the Socket connection to check my changes after refreshing the page.

Can you please provide me the solution for that?

Waiting for your response.

P.S. : I think in result.js file for socket.on message event it is calling "init" method every time. but when update occurs it should call "diff" method.

[dhvanipurohit]

Thank you so much for this example.

I got the solution.

We do not need to change anything in the code.

Just need to change configuration in mysql.ini file.

For that,

1. we can directly change in the mysql.ini file.
   like,
   binlog_format = row
   OR
2. when connection established you can fire following query,
   liveDb.db.query('SET GLOBAL binlog_format = "ROW"');
   but, this will work for current session only.

Thanks.

[barmao]

@dhvanipurohit you could close the issue if you found a solution 😃