List updated when a row was insert/updated in DB

Question

I'm working with java/wicket and I need to develop a functionality that shows on real time, every new request that arrives from clients_request table into a list in the page.

I make this functionality with a script that every second clicks a button that query the bd and then reload all the table content.

There are any way to observe the bd and reload the page only when a new change on this table occurs ?

Answer 1

If you would like the server to handle the updates (push instead of pull), you can use WebSockets, as can be seen here: http://wicketinaction.com/2012/07/wicket-6-native-websockets/

Answer 2

Instead of programatically clicking a button change it at least to use a AjaxSelfUpdatingTimerBehavior