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)

Common Space

Common Space

This episode examines the Common Space initiative, a non-profit project dedicated to building and launching high-resolution optical satellites designed specifically for humanitarian purposes, such as ...

22 Maalis 38min

AI in QGIS

AI in QGIS

I've been playing around with a lot of large language models lately, and it is absolutely fascinating to watch them work. But what happens when you bring that directly into QGIS? Right now, AI in the ...

5 Maalis 49min

Geospatial Makers Start Building!

Geospatial Makers Start Building!

Geospatial Product Swiss Army Knife 1. The "Build It and They Won't Come" Trap We have all seen it: a talented geospatial professional spends months—perhaps years—perfecting a technically sophisticate...

11 Helmi 46min

Vibe Coding and the Fragmentation of Open Source

Vibe Coding and the Fragmentation of Open Source

Why Machine-Writing Code is the Best (and Most Dangerous) Thing for Geospatial:   The current discourse surrounding AI coding is nothing if not polarized. On one side, the technofuturists urge us to ...

3 Helmi 36min

A5 Pentagons Are the New Bestagons

A5 Pentagons Are the New Bestagons

How can you accurately aggregate and compare point-based data from different parts of the world? When analyzing crime rates, population, or environmental factors, how do you divide the entire globe in...

19 Tammi 37min

The Sustainable Path for Open Source Businesses

The Sustainable Path for Open Source Businesses

The Open-Source Conundrum   Many successful open-source projects begin with passion, but the path from a community-driven tool to a sustainable business is often a trap.   The most common route—relyi...

8 Tammi 36min

Free Software and Expensive Threats

Free Software and Expensive Threats

Open-source software is often described as "free," a cornerstone of the modern digital world available for anyone to download, use, and modify. But this perception of "free" masks a growing and invisi...

26 Joulu 202534min

Mapping Your Own World: Open Drones and Localized AI

Mapping Your Own World: Open Drones and Localized AI

What if communities could map their own worlds using low-cost drones and open AI models instead of waiting for expensive satellite imagery? In this episode with Leen from HOT (Humanitarian OpenStreetM...

18 Joulu 202532min

Suosittua kategoriassa Tiede

rss-mita-tulisi-tietaa
tiedekulma-podcast
rss-poliisin-mieli
utelias-mieli
rss-duodecim-lehti
docemilia
mielipaivakirja
university-of-eastern-finland
vinkista-vihia
rss-vaasan-yliopiston-podcastit
rss-duokkari-ekstra
rss-metsantuntijat-podcast
rss-ilmasto-kriisissa
rss-pandapodi
rss-luontopodi-samuel-glassar-tutkii-luonnon-ihmeita
rss-sosiopodi
rss-miljonaarien-tasavalta