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)

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 Mar 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 Mar 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 Feb 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 Feb 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 Jan 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 Jan 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 Des 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 Des 202532min

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