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)

Introduction to Cloud Native Geospatial

Introduction to Cloud Native Geospatial

Alex Leith is a Digital Earth Architect and in this episode, you will learn what Infrastructure as code is  - hint it is the opposite of the "clicky-clicky" and so much more! Connect with Alex here ht...

26 Tammi 202455min

GeeMap

GeeMap

GeeMap is an open-source Python library that provides tools for interactive mapping with Google Earth Engine (GEE), which is a platform for earth science data and analysis ... and today you are going ...

9 Tammi 202454min

GPS Reimagined

GPS Reimagined

GPS reimagined? Why do we need to reimagine GPS? ... Is it broken?   Recommended Podcast Episodes   How Google Calculates Your Location https://mapscaping.com/podcast/how-google-calculates-your-locati...

27 Joulu 202345min

The Business of QGIS Development

The Business of QGIS Development

Nyall Dawson is a QGIS developer, cartographer, and owner and founder of North Road, a company specializing in open-source geospatial software. His journey into geospatial began with personal interest...

20 Joulu 202352min

Making Beautiful Maps In Felt

Making Beautiful Maps In Felt

This episode is all about making beautiful maps ... I am not a cartographer but my guest Mamata Akella is a professional cartographer at Felt!  So today on the podcast we are talking about Essential E...

14 Joulu 202352min

Planet - Imaging Everything, Every Day ... Almost

Planet - Imaging Everything, Every Day ... Almost

Planet manufactures and manages the world’s largest constellation of earth observation satellites! Imaging “Just about everywhere on earth just about every day – Making change visible, accessible, and...

6 Joulu 202345min

Fire Mapping, Maritime Search And Wide Angle Imaging

Fire Mapping, Maritime Search And Wide Angle Imaging

This episode is a story about wide-angle imaging for fire mapping and maritime search but it's also a story about changing the culture and getting people to trust a new way of doing things.   My guest...

30 Marras 202346min

Personal Branding in Geospatial

Personal Branding in Geospatial

It's not about becoming an influencer it's about creating opportunities for yourself   In this episode, we tackle the common misconception that personal branding is solely for influencers, revealing h...

22 Marras 202350min

Suosittua kategoriassa Tiede

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