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

Jaksot(254)

Tracking Elephants

Tracking Elephants

Tracking elephants in Southern Africa’s Kavango-Zambezi (KAZA) region, the largest transfrontier conservation area in the world. Lead scientist Robin Naidoo from the World Wildlife Fund-US explains th...

6 Marras 202445min

Female Voices in Geospatial

Female Voices in Geospatial

Today's episode touches on some pretty big topics like Imposter Syndrome, Mentorship, Career Progression, Adaptability and Diversity Today you are going to hear two stories from two very different voi...

25 Syys 202442min

QField

QField

In this episode, Marco Bernasconi, co-founder and CEO of OPENGIS.ch, introduces us to QField, an open-source mobile application designed for field data collection in conjunction with QGIS. Marco share...

18 Syys 202449min

Analyst To Engineer

Analyst To Engineer

This is the story of Priscilla Cole, and what she did when she discovered that her ambitions were bigger than the tools she was using! Connect with Priscilla here! https://www.linkedin.com/in/priscill...

28 Elo 202441min

Satclip - Encoding Location

Satclip - Encoding Location

In this episode, I'm joined by Konstantine Klemmer, a researcher at Microsoft, to dive deep into the fascinating world of GeoAI. Konstantine introduces us to Satclip, a cutting-edge model that encodes...

16 Elo 202443min

Natural Language Geocoding

Natural Language Geocoding

In this episode, I welcome Jason Gilman, a Principal Software Engineer at Element 84, to explore the exciting world of natural language geocoding. Key Topics Discussed: Introduction to Natural Langua...

1 Elo 202445min

Semantic Search For Geospatial

Semantic Search For Geospatial

This podcast episode is all about semantic search and using embeddings to analyse text and social media data. Dominik Weckmüller, a researcher at the Technical University of Dresden, talks about his P...

10 Heinä 202450min

Why You Should Care About L Band

Why You Should Care About L Band

In this episode, we welcome back Lauren Guy, CEO and founder of ASTERRA, a groundbreaking company using L band and synthetic aperture radar (SAR) for commercial purposes. Lauren shares his journey as ...

5 Kesä 202451min

Suosittua kategoriassa Tiede

rss-poliisin-mieli
tiedekulma-podcast
rss-mita-tulisi-tietaa
rss-tiedetta-vai-tarinaa
rss-duodecim-lehti
rss-lihavuudesta-podcast
utelias-mieli
radio-antro
filocast-filosofian-perusteet
university-of-eastern-finland
docemilia
hippokrateen-vastaanotolla
rss-kasvatuspsykologiaa-kaikille
rss-astetta-parempi-elama-podcast
rss-tervetta-skeptisyytta
rss-lapsuuden-rakentajat-podcast
rss-sosiopodi