PostgreSQL - Listen and Notify Clients In Real Time
The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography
00:00
How to Use Listen Notify to Update a Database Map
There's this functionality in the database called listen notify, we can attach triggers to that. So it's possible for the map to update itself in a very granular way. It does not just have to go back and pull the whole table again, redraw the whole thing. It can in fact move objects one at a time. And also you can subsume a lot of the complexity into the database side.
Transcript
Play full episode
