2min chapter

The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography cover image

PostgreSQL - Listen and Notify Clients In Real Time

The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography

CHAPTER

The Importance of Centralizing the Model and Database

Right now, if you see a map self updating, there's a strong likelihood that it's pulling. The nice thing about centralizing the model and the database is that my understanding of the state of the system is entirely contained in the database tables. And so it means that any client which can talk directly to the PostGIS tables can participate in this live data.

00:00

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode