What are some example use cases where having the ability for the database to push updates to an application would be helpful (vs. the traditional polling approach)?
If it is built into your language/framework, you can completely ignore the problem of updating the client, as it happens automatically.
Hope that makes sense.
You may want to search for realtime databases.