maz
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? I’ve seen supabase but that appears to be for JS.
I’m just trying to learn LiveView and everything I’ve found about is so far in terms of examples is user-initiated actions changing state rather than server events. In another forum someone recommended looking into Change Data Capture but I think if I followed the CDC path I would get bogged-down in the details of CDC rather than develop the frontend.
Where Next?
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #elixirconf-eu
- #metaprogramming
- #hex
Our Sponsors
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Producing high quality Elixir screencasts since 2017.
**Building the future of software with AI, trust, and human connection.**
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 6- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
kokolegorille
Check postgresql triggers, You can do this with them…
exjutsu
https://blog.lelonek.me/listen-and-notify-postgresql-commands-in-elixir-187c49597851
That will tell you how to have PG notify the application. You’ll want to see a LiveView PubSub example for the interface update.
maz
Yes thanks I think this is what I was looking for. My presumption is that I can do a broadcast() once I get that table update event. I won’t mark it as “solution” until I implement it though.
mindok
Yes - the wire-up for listening to broadcasts is shown here…
shanesveller
If the code/feature doing the original database inserts is part of the same application that is presenting these items in a LiveView, I’d reach for Phoenix.PubSub. You can have your LiveView processes subscribe to a topic for new insertions, and have the area that performs the insertions emit an event on that topic or topics.
kokolegorille
For insertion it’s fine, but I did not find a good way to detect cascading deletion without triggers.