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

Tämä jakso on lisätty Podme-palveluun avoimen RSS-syötteen kautta eikä se ole Podmen omaa tuotantoa. Siksi jakso saattaa sisältää mainontaa.

Jaksot(266)

Fields Of The World

Fields Of The World

Where does one field end and the next one begin? It sounds trivial right up until you try to answer it. In this episode, I'm joined by Hannah Kerner — Assistant Professor at Arizona State University, ...

18 Elo 43min

Virtual Worlds for Physical AI Systems

Virtual Worlds for Physical AI Systems

In this episode I'm joined by Apurva Shah, co-founder and CEO of Duality AI, a company building virtual worlds — or "world models" for robots and physical AI systems. Apurva's path here is an unusual ...

4 Elo 49min

GPS, But 100 Times Stronger

GPS, But 100 Times Stronger

My guest today is Tyler Reid, co-founder and CTO of Xona, a company building the first commercial satellite navigation system. We get into why Tyler and his team are moving satellites into low Earth o...

29 Heinä 43min

Turning Aerial Imagery Into a Searchable World

Turning Aerial Imagery Into a Searchable World

Vexcel isn't a household name — but you've almost certainly used their data. This aerial imaging company flies low-elevation aircraft across roughly 45 countries, capturing imagery at 7.5cm resolution...

28 Heinä 55min

Cloud Native for the Rest of Us

Cloud Native for the Rest of Us

What happens when you take cloud native geospatial out of the satellite-and-petabyte world and drop it into a small city with no budget and the world's slowest internet connection? In this episode, Da...

20 Heinä 38min

Mapping With 360 Cameras

Mapping With 360 Cameras

Jeffrey Martin is the co-founder and CEO of Mosaic, a company building 360-degree camera systems designed specifically for mapping. He's been obsessed with 360 imagery for over 20 years — he built one...

15 Heinä 41min

Who Pays for Open Source?

Who Pays for Open Source?

Open source software runs a huge chunk of the geospatial world — but somebody still has to pay for it. In this episode I sit down with Marco Bernasocchi creator of QField and CEO of OpenGIS.ch, to dig...

1 Heinä 54min

The Great Retooling

The Great Retooling

Ian Schuler is the CEO of Development Seed — the team behind a lot of the open source tooling that quietly holds up the geospatial world. He's been at the helm for over a decade, and in this conversat...

23 Kesä 44min

Suosittua kategoriassa Tiede

rss-poliisin-mieli
tiedekulma-podcast
utelias-mieli
rss-mita-tulisi-tietaa
docemilia
rss-hereilla
rss-duodecim-lehti
rss-luontopodi-samuel-glassar-tutkii-luonnon-ihmeita
rss-astetta-parempi-elama-podcast
rss-tiedetta-vai-tarinaa
rss-ylistys-elaimille
mielipaivakirja
sotataidon-ytimessa
rss-sotepodi-ratkaisuja-hyvinvointiin
rss-kasvikutsut
rss-ammamafia
rss-bios-podcast
rss-tervetta-skeptisyytta
ihanat-ipanat