{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Database School","title":"Just use Postgres with Denis Magda","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/5ee33dea\"></iframe>","width":"100%","height":180,"duration":4079,"description":"In this episode, Aaron talks with Dennis Magda, author of Just Use Postgres!, about the wide world of modern Postgres, from JSON and full-text search to generative AI, time-series storage, and even message queues. They explore when Postgres should be your go-to tool, when it shouldn’t, and why understanding its breadth helps developers build better systems.\nUse the code DBSmagda to get 45% off Denis' new book Just Use Postgres!\nOrder Just Use Postgres!\nFollow Denis:\nTwitter/X:  https://twitter.com/denismagda\nLinkedIn: https://www.linkedin.com/in/dmagda\nFollow Aaron:\nTwitter/X:  https://twitter.com/aarondfrancis \nDatabase School: https://databaseschool.com\nDatabase School YouTube Channel: https://www.youtube.com/@UCT3XN4RtcFhmrWl8tf_o49g  (Subscribe today)\nLinkedIn: https://www.linkedin.com/in/aarondfrancis\nWebsite: https://aaronfrancis.com - find articles, podcasts, courses, and more.\nChapters:\n00:00 – Welcome\n01:28 – Dennis’ Background: Java, JVM, and Databases\n03:20 – Bridging Application Development & Databases\n04:05 – Moving Down the Stack: How Dennis Entered Databases\n07:28 – Apache Ignite, Distributed Systems & the Path to Postgres\n08:02 – Writing Just Use Postgres!: The Origin Story\n10:26 – Why a Modern Postgres Book Was Needed\n11:01 – The Spark That Led to the Book Proposal\n13:06 – Developers Still Don’t Know What Postgres Can Do\n15:40 – Connecting With Manning & Refining the Book Vision\n16:38 – What Just Use Postgres! Covers\n17:40 – The Book’s Core Thesis: The Breadth of Postgres\n19:50 – Favorite Use Cases & Learning While Writing\n20:30 – When to Use Postgres for Non-Relational Workloads\n23:08 – Full Text Search in Postgres Explained\n29:31 – When Not to Use Postgres (Pragmatism Over Fanaticism)\n34:01 – Using Postgres as a Message Queue\n42:09 – When Message Queues Outgrow Postgres\n48:10 – Postgres for Generative AI (PGVector)\n55:34 – Dennis’ 14-Month Writing Process\n01:00:50 – Who the Book Is For\n01:04:10 – Where to Follow Dennis & Closing Thoughts","thumbnail_url":"https://img.transistorcdn.com/QPpKhRBWtM56k1sC7Y7j7aqGy8sd-XKWw6mEKgA1jmw/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9lMmRl/ZTM5ZTAxOTMzNTgy/MmJmZTA4MWE1ZjMw/YjE4Ny5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}