How can we, humans, look at our relationship to nature differently? In season three of Going Wild, on top of stories about animals, we invite you to journey through the entire ecological web — from the tiniest of life forms to apex predators — alongside the scientists, activists and adventurers who study it. Wildlife biologist and host Dr. Rae Wynn-Grant has been studying wild animals in their natural habitats all over the world for years. Our award-winning podcast takes you inside the hidde ...
…
continue reading
Contenuto fornito da MapScaping. Tutti i contenuti dei podcast, inclusi episodi, grafica e descrizioni dei podcast, vengono caricati e forniti direttamente da MapScaping o dal partner della piattaforma podcast. Se ritieni che qualcuno stia utilizzando la tua opera protetta da copyright senza la tua autorizzazione, puoi seguire la procedura descritta qui https://it.player.fm/legal.
Simile a The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography
Artificial Intelligence has suddenly gone from the fringes of science to being everywhere. So how did we get here? And where's this all heading? In this new series of Science Friction, we're finding out.
…
continue reading
The Science Show gives Australians unique insights into the latest scientific research and debate, from the physics of cricket to prime ministerial biorhythms.
…
continue reading
Flash Forward is a show about possible (and not so possible) future scenarios. What would the warranty on a sex robot look like? How would diplomacy work if we couldn’t lie? Could there ever be a fecal transplant black market? (Complicated, it wouldn’t, and yes, respectively, in case you’re curious.) Hosted and produced by award winning science journalist Rose Eveleth, each episode combines audio drama and journalism to go deep on potential tomorrows, and uncovers what those futures might re ...
…
continue reading
Whether the topic is popcorn or particle physics, you can count on BrainStuff to explore -- and explain -- the everyday science in the world around us.
…
continue reading
A myriad of AI, science, and technology experts explore the real challenges and enormous opportunities facing entrepreneurs who are building the future of health. Raising Health, a podcast by a16z Bio + Health and hosted by Kris Tatiossian and Olivia Webb, dives deep into the heart of biotechnology and healthcare innovation. Join veteran company builders, operators, and investors Vijay Pande, Julie Yoo, Vineeta Agarwala, and Jorge Conde, along with distinguished guests like Mark Cuban, Greg ...
…
continue reading
The kickass science and technology radio show that delivers an irreverent look at the week in science and technology.
…
continue reading
Embedded is the show for people who love gadgets. Making them, breaking them, and everything in between. Weekly interviews with engineers, educators, and enthusiasts. Find the show, blog, and more at embedded.fm.
…
continue reading
Come dive into one of the curiously delightful conversations overheard at National Geographic’s headquarters, as we follow explorers, photographers, and scientists to the edges of our big, weird, beautiful world. Hosted by Peter Gwin and Amy Briggs.
…
continue reading
Get ready to have your spine tingling and your hairs standing on end with the Daily Paranormal Podcast hosted by Tony Brueski. This show is no joke - it's packed with real-life horror stories of ghosts, demons, haunted houses, possessions, shadow people, and all things supernatural that will leave you quivering with fear. Our listeners can't get enough of our bone-chilling tales, describing them as the "best ghost story podcast out there." Don't expect the same old cliché zombies, vampires, ...
…
continue reading
Player FM - App Podcast
Vai offline con l'app Player FM !
Vai offline con l'app Player FM !
))
The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography
«
»
PostgreSQL - Listen and Notify Clients In Real Time
Manage episode 367251801 series 2502116
Contenuto fornito da MapScaping. Tutti i contenuti dei podcast, inclusi episodi, grafica e descrizioni dei podcast, vengono caricati e forniti direttamente da MapScaping o dal partner della piattaforma podcast. Se ritieni che qualcuno stia utilizzando la tua opera protetta da copyright senza la tua autorizzazione, puoi seguire la procedura descritta qui https://it.player.fm/legal.
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!
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
238 episodi
PostgreSQL - Listen and Notify Clients In Real Time
The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography
Condividi
Manage episode 367251801 series 2502116
Contenuto fornito da MapScaping. Tutti i contenuti dei podcast, inclusi episodi, grafica e descrizioni dei podcast, vengono caricati e forniti direttamente da MapScaping o dal partner della piattaforma podcast. Se ritieni che qualcuno stia utilizzando la tua opera protetta da copyright senza la tua autorizzazione, puoi seguire la procedura descritta qui https://it.player.fm/legal.
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!
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
238 episodi
كل الحلقات
×
Benvenuto su Player FM!
Player FM ricerca sul web podcast di alta qualità che tu possa goderti adesso. È la migliore app di podcast e funziona su Android, iPhone e web. Registrati per sincronizzare le iscrizioni su tutti i tuoi dispositivi.
Simile a The MapScaping Podcast - GIS, Geospatial, Remote Sensing, earth observation and digital geography
How can we, humans, look at our relationship to nature differently? In season three of Going Wild, on top of stories about animals, we invite you to journey through the entire ecological web — from the tiniest of life forms to apex predators — alongside the scientists, activists and adventurers who study it. Wildlife biologist and host Dr. Rae Wynn-Grant has been studying wild animals in their natural habitats all over the world for years. Our award-winning podcast takes you inside the hidde ...
…
continue reading
Artificial Intelligence has suddenly gone from the fringes of science to being everywhere. So how did we get here? And where's this all heading? In this new series of Science Friction, we're finding out.
…
continue reading
The Science Show gives Australians unique insights into the latest scientific research and debate, from the physics of cricket to prime ministerial biorhythms.
…
continue reading
Flash Forward is a show about possible (and not so possible) future scenarios. What would the warranty on a sex robot look like? How would diplomacy work if we couldn’t lie? Could there ever be a fecal transplant black market? (Complicated, it wouldn’t, and yes, respectively, in case you’re curious.) Hosted and produced by award winning science journalist Rose Eveleth, each episode combines audio drama and journalism to go deep on potential tomorrows, and uncovers what those futures might re ...
…
continue reading
Whether the topic is popcorn or particle physics, you can count on BrainStuff to explore -- and explain -- the everyday science in the world around us.
…
continue reading
A myriad of AI, science, and technology experts explore the real challenges and enormous opportunities facing entrepreneurs who are building the future of health. Raising Health, a podcast by a16z Bio + Health and hosted by Kris Tatiossian and Olivia Webb, dives deep into the heart of biotechnology and healthcare innovation. Join veteran company builders, operators, and investors Vijay Pande, Julie Yoo, Vineeta Agarwala, and Jorge Conde, along with distinguished guests like Mark Cuban, Greg ...
…
continue reading
The kickass science and technology radio show that delivers an irreverent look at the week in science and technology.
…
continue reading
Embedded is the show for people who love gadgets. Making them, breaking them, and everything in between. Weekly interviews with engineers, educators, and enthusiasts. Find the show, blog, and more at embedded.fm.
…
continue reading
Come dive into one of the curiously delightful conversations overheard at National Geographic’s headquarters, as we follow explorers, photographers, and scientists to the edges of our big, weird, beautiful world. Hosted by Peter Gwin and Amy Briggs.
…
continue reading
Get ready to have your spine tingling and your hairs standing on end with the Daily Paranormal Podcast hosted by Tony Brueski. This show is no joke - it's packed with real-life horror stories of ghosts, demons, haunted houses, possessions, shadow people, and all things supernatural that will leave you quivering with fear. Our listeners can't get enough of our bone-chilling tales, describing them as the "best ghost story podcast out there." Don't expect the same old cliché zombies, vampires, ...
…
continue reading
Player FM - App Podcast
Vai offline con l'app Player FM !
Vai offline con l'app Player FM !
