PostgreSQL - Listen and Notify Clients In Real Time
The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography28 Jun 2023

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)

GeoParquet For Beginners

GeoParquet For Beginners

Cloud-native geospatial, range requests, chucks, COGs and COPCs ... [ insert confusing acronym here ]  Sometimes It feels like we need to learn a whole new vocabulary and if you have been doing #geo f...

23 Mai 202442min

Finding Stuff Indoors

Finding Stuff Indoors

Mappedin started as a school project and evolved into a leading indoor mapping company, working with malls, airports, hospitals, and Fortune 500 companies.   You guessed, today's podcast is all about ...

16 Mai 202449min

What is humanitarian GIS?

What is humanitarian GIS?

Hugo Powell, from immap.org shares his expert insights on how GIS technologies are leveraged to analyze data, visualize scenarios, and facilitate rapid decision-making during emergencies. Here are the...

1 Mai 202447min

AI Autocomplete for QGIS

AI Autocomplete for QGIS

AI Autocomplete for QGIS Brendan Ashworth the CTO and co-founder of https://buntinglabs.com/ focuses on integrating AI with QGIS, and today on the podcast we are talking about Autocomplete for vectori...

12 Apr 202442min

GNSS receivers - why precise positioning will not be coming to your phone any time soon

GNSS receivers - why precise positioning will not be coming to your phone any time soon

GNSS receivers - why precise positioning will not be coming to your phone any time soon   Igor is the CEO and cofounder of Emlid.com a company that started out making high-precision GNSS receivers in ...

21 Mar 202451min

The way you talk about your geospatial skills is costing you money

The way you talk about your geospatial skills is costing you money

Refactoring the Way you Talk About your geospatial skills: It is Costing you Money Some of the key topics in this episode  1.Our Geospatial Skills and Marketability: There's a realization that while o...

15 Mar 202452min

Modern Geospatial

Modern Geospatial

Modern geospatial - not the bleeding edge of geospatial but modern geospatial - what is it? Well my guest Will Cadell, the CEO of SparkGeo describes modern geospatial as the intersection of the cloud,...

29 Feb 202448min

Introduction To LIDAR & Point Clouds

Introduction To LIDAR & Point Clouds

The main topics discussed during this episode include: Basics of LIDAR data and its applications. Differences between LIDAR and photogrammetry. Processing chain of LIDAR data. Challenges in classifyin...

15 Feb 202448min

Populært innen Vitenskap

fastlegen
jss
tingenes-tilstand
rekommandert
sinnsyn
forskningno
liberal-halvtime
tomprat-med-gunnar-tjomlid
rss-paradigmepodden
rss-nysgjerrige-norge
villmarksliv
kvinnehelsepodden
fjellsportpodden
nevropodden
nordnorsk-historie
rss-overskuddsliv
rss-rekommandert
diagnose
rss-bondevennen
psykopoden