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
Hub Ocean
Felt - Upload Anything
The Rapid Editor
Applying For A Job, Getting Picked and Negotiating The Contract
Using Lasers To Talk To Satellites
From Pixels to Patterns: AI in Spatial Analysis
pygeoapi - A Python Geospatial Server
Big Data In The Browser
Rasters In A Database?
Spatial Knowledge Graphs
ChatGPT and Large Language Models
Computer Vision and GeoAI
Designing for Location Privacy
Hyperspectral vs Multispectral
All Of The Places In The World
Planet Scale Tiled Maps Without A Server
Storytelling With Point Clouds
Geospatial Archaeology
Navigating the World of Geospatial Standards
Create your
podcast in
minutes
It is Free
Regenerative Agriculture Podcast
Bedrock: Earth’s Earliest History
Kosmographia
The Great Simplification with Nate Hagens
Climate One