PostgreSQL - Listen and Notify Clients In Real Time

The promise of digital mapping is to provide a shared and real-time view of the state of the underlying system.

pg_eventserv is a free and open-source component that helps fulfill the promise of real-time event modeling and shared views in PostgreSQL.

By connecting to PostgreSQL and listening on specified channels, pg_eventserv captures database notifications and forwards them to web clients, enabling real-time updates and synchronization of data displayed on maps or other web interfaces.

pg_eventserv does one thing and one thing only: take events generated by the PostgreSQL NOTIFY command and passes the payload along to waiting WebSockets clients.

pg_eventserv is free and easy to install and you can find it here: https://github.com/CrunchyData/pg_eventserv

What this means is that any client can watch for notifications and update as changes in the database happen.

Real-time data!

Here is a link to a Youtube video demonstration of pg_eventserv in action!

https://youtu.be/UakRtYmoWow

I will let Paul Ramsey the creator of pg_eventserv explain all this in more detail in this episode.

If you want to reach out to Paul the best place to do that is http://blog.cleverelephant.ca/

Or if you want to listen to previous episodes with Paul you might find these interesting

Raster in the database?

https://mapscaping.com/podcast/rasters-in-a-database/

Dynamic Vector Tiles Straight From The Database

https://mapscaping.com/podcast/dynamic-vector-tiles-straight-from-the-database/

Spatial SQL- GIS Without The GIS

https://mapscaping.com/podcast/spatial-sql-gis-without-the-gis/

also ... If you are interested in spatial databases at scale ... you might find this episode interesting

https://mapscaping.com/podcast/distributing-geospatial-data/

Some more episodes you might enjoy

ESRI, GIS careers, Geospatial Data Science

QGIS, Geospatial Python, ArcGIS Pro

Google Maps, Geomatics, Cartography

Location Intelligence, Mapping

Episoder(254)

From Data Dump to Data Product

From Data Dump to Data Product

This conversation with Jed Sundwall, Executive Director of Radiant Earth, starts with a simple but crucial distinction: the difference between data and data products. And that distinction matters more...

9 Des 202545min

Reflections from FOSS4G 2025

Reflections from FOSS4G 2025

Reflections from the FOSS4G 2025 conference    Processing, Analysis, and Infrastructure (FOSS4G is Critical Infrastructure) The high volume of talks on extracting meaning from geospatial data—includin...

2 Des 202513min

Building a Community of Geospatial Storytellers

Building a Community of Geospatial Storytellers

Karl returns to the Mapscaping podcast to discuss his latest venture, Tyche Insights - a platform aimed at building a global community of geospatial storytellers working with open data. In this conver...

27 Nov 202542min

I have been making AI slop and you should too

I have been making AI slop and you should too

AI Slop: An Experiment in Discovery Solo Episode Reflection: I'm back behind the mic after about a year-long break. Producing this podcast takes more time than you might imagine, and I was pretty burn...

17 Nov 202518min

Scribble: An AI Agent for Web Mapping

Scribble: An AI Agent for Web Mapping

Jonathan Wagner, CEO of Scribble Maps, is back on the podcast, and this time we're talking about Scribble—an AI agent he's built into his platform. Not a chatbot, an agent. There's a difference, and w...

10 Nov 202548min

Mapillary

Mapillary

Exploring the Evolution and Impact of Mapillary with Ed from Meta.  Topics include Ed's journey with Mapillary, the process of uploading and utilizing street-level imagery, and the integration with Op...

27 Okt 202548min

Telematics Data is Reshaping Our Understanding of Road Networks

Telematics Data is Reshaping Our Understanding of Road Networks

Telematics Data is Reshaping Our Understanding of Road Networks In this episode MIT Professor Hari Balakrishnan explains how Cambridge Mobile Telematics (CMT) is transforming traditional road network ...

9 Jan 202558min

Hivemapper

Hivemapper

In this week’s episode, I’m thrilled to welcome back Ariel Seidman, founder of HiveMapper. Ariel was my very first podcast guest back in 2019, and HiveMapper has come a long way since then! We explore...

5 Des 202451min

Populært innen Vitenskap

fastlegen
tingenes-tilstand
rekommandert
jss
rss-rekommandert
sinnsyn
liberal-halvtime
forskningno
dekodet-2
villmarksliv
rss-nysgjerrige-norge
rss-paradigmepodden
tomprat-med-gunnar-tjomlid
tidlose-historier
smart-forklart
fjellsportpodden
hva-er-greia-med
kvinnehelsepodden
vett-og-vitenskap-med-gaute-einevoll
rss-inn-til-kjernen-med-sunniva-rose