{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Talking Postgres with Claire Giordano","title":"Building a dev experience for Postgres in VS Code with Rob Emanuele","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/59332d5a\"></iframe>","width":"100%","height":180,"duration":4720,"description":"What do guitar busking, geospatial queries, and agentic coding have to do with Postgres? In Episode 33 of Talking Postgres, principal engineer Rob Emanuele at Microsoft shares his winding path from Venice Beach to building a new VS Code extension for PostgreSQL—that works with any Postgres, anywhere. We dig into GitHub Copilot, ask vs. agent mode, and how Rob now codes in English—and then spends even more time in code review to decide what’s good, what’s bad, and what’s dangerous. Also: how PyCon changed his life; his work on the Microsoft Planetary Computer with spatio-temporal queries and PostGIS; and how music, improv, and failure shape his approach to developer experience. \n\nLinks mentioned in this episode:\nVisual Studio Marketplace: VS Code extension for PostgreSQL with ~261K downloads to date\nGitHub repo: VS Code extension for PostgreSQL (for issues/discussions)\nDocs: GitHub Copilot agent mode\nPOSETTE 2025 Talk: Introducing Microsoft’s VS Code Extension for PostgreSQL, by Matt McFarland\nVS Code Live: Working with PostgreSQL databases with the Microsoft PostgreSQL VS Code extension, with Olivia Guzzardo & Rob Emanuele\nTalking Postgres Ep30: AI for data engineers with Simon Willison\nPostgres Meetup for All: VS Code Tools for Postgres, happening on Thu Dec 11, 2025 \nWikipedia: Dogfooding\nTalking Postgres Ep07: Why people care about PostGIS and Postgres with Paul Ramsey & Regina Obe\nPOSETTE 2024 keynote: The Open Source Geospatial Community, PostGIS, & Postgres, by Regina Obe\nWebsite: Microsoft Planetary Computer\nGitHub repo: PgSTAC\nCal invite: LIVE recording of Ep34 of Talking Postgres to happen on Wed Dec 10, 2025","thumbnail_url":"https://img.transistorcdn.com/96oK6oMtH0qfumCURmVA4Hg7enGdZ1swehO6BOYsd8w/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS84OWEw/YmE3ZDQ5MDI3NzA5/MTljZThlODg3N2Qy/M2M1YS5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}