Postgres Build 2021 has ended
Back To Schedule
Wednesday, December 1 • 11:45am - 12:25pm
An infrastructure-as-code approach to PostgreSQL-backed IoT sensor data sharing

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

The British Geological Survey's sensor data API is backed by PostgreSQL databases.
It has been built via an infrastructure-as-code approach using Docker, Ansible, Flyway and GitLab CI.
Streaming replication via pglogical provides redundancy and selected publication of data.
This talk outlines the architecture explains some of the benefits of this approach

avatar for John Stevenson

John Stevenson

Senior Software Developer, British Geological Survey
Dr. John A. Stevenson is a geologist turned software developer at the British Geological survey.  He is interested in data engineering, with an emphasis on scientific and geospatial data.He likes using open source tools (PostgreSQL, Python, Linux, Git) because they make it easy to... Read More →

Wednesday December 1, 2021 11:45am - 12:25pm GMT