Detecting Postgresql Table Change for LiveView

[Exadra37]

@michael

So I have a table of MediaItems and when that list changes, say new entries, I’d like LiveView to know about that so that the Timeline updates automatically. How to know when the table updates?

You use Phoenix PubSub to broadcast them each time you create, update or delete them.

Then in the handle_info on your live view you can use send_update/2 to update the client.

Some useful links:

• Phoenix LiveView Tutorial: PubSub and Pow Authentication | Curiosum
• Building Real-Time Features with Phoenix Live View and PubSub | Blog · Elixir School