Building PostgreSQL for the Future with Heikki Linnakangas

Building PostgreSQL for the Future with Heikki Linnakangas

Author: softwareengineeringdaily.com May 20, 2025 Duration: 42:12
PostgreSQL is an open-source database known for its robustness, extensibility, and compliance with SQL standards. Its ability to handle complex queries and maintain high data integrity has made it a top choice for both start-ups and large enterprises. Heikki Linnakangas is a leading developer for the PostgreSQL project, and he's a co-founder at Neon, which provides a serverless platform for spinning up Postgres databases. In this episode, he joins Kevin Ball to talk about why PostgreSQL has become so popular, why he founded Neon, Postgres Core vs. Extensions, the pgvector similarity search for AI applications, and much more. Full Disclosure: This episode is sponsored by Neon.   Kevin Ball or KBall, is the vice president of engineering at Mento and an independent coach for engineers and engineering leaders. He co-founded and served as CTO for two companies, founded the San Diego JavaScript meetup, and organizes the AI inaction discussion group through Latent Space. Please click here to see the transcript of this episode. Sponsorship inquiries: sponsor@softwareengineeringdaily.com

For anyone curious about how the code running our world actually gets built, Software Engineering Daily offers a clear and consistent look behind the curtain. This isn't about hype cycles or surface-level news; it's a deep, technical conversation with the engineers, architects, and thinkers who are shaping our digital infrastructure. Each episode focuses on a specific technology, practice, or problem, breaking down complex systems into understandable parts. You'll hear detailed discussions on everything from database architectures and programming language design to the organizational challenges of scaling teams and the real-world trade-offs made in production systems. Hosted by softwareengineeringdaily.com, the podcast serves as a reliable source for developers who want to stay informed and inspired, translating the rapid pace of technological change into substantive, lasting knowledge. It’s for professionals who believe that understanding the "how" and "why" is just as important as knowing the "what." By dedicating time to thorough exploration, this podcast provides context that shorter formats simply cannot, making it an essential resource for anyone building the future, one line of code at a time. Tune in to hear unfiltered insights from the people on the front lines, discussing the tools and decisions that define modern software engineering.
Author: Language: en-us Episodes: 100

Software Engineering Daily
Podcast Episodes
Prettier and Opinionated Code Formatting with James Long [not-audio_url] [/not-audio_url]

Duration: 51:07
Developer tooling shapes how software gets written day to day, but the best tools often disappear into the background once they succeed. Formatting, linting, and build systems can either create friction and endless debat…
Skate Story with Sam Eng [not-audio_url] [/not-audio_url]

Duration: 58:07
Skateboarding games have long balanced technical precision with a sense of flow and expression, but Skate Story takes the genre in a radically different direction. It has a distinct vaporwave vibe and blends fluid skate…
DeepMind’s RAG System with Animesh Chatterji and Ivan Solovyev [not-audio_url] [/not-audio_url]

Duration: 40:57
Retrieval-augmented generation, or RAG, has become a foundational approach to building production AI systems. However, deploying RAG in practice can be complex and costly. Developers typically have to manage vector datab…
Reinventing the Python Notebook with Akshay Agrawal [not-audio_url] [/not-audio_url]

Duration: 49:04
Interactive notebooks were popularized by the Jupyter project and have since become a core tool for data science, research, and data exploration. However, traditional, imperative notebooks often break down as projects gr…
Organizational Context for AI Coding Agents with Dennis Pilarinos [not-audio_url] [/not-audio_url]

Duration: 49:21
AI agents have taken on a growing share of software development work, so much so that the hardest problems are shifting away from code generation towards something new, context. The challenge is now contextualizing why s…
Amazon’s IDE for Spec-Driven Development with David Yanacek [not-audio_url] [/not-audio_url]

Duration: 59:00
AI-assisted coding tools have made it easier than ever to spin up prototypes, but turning those prototypes into reliable, production-grade systems remains a major challenge. Large language models are non-deterministic, p…
Engineering AI Systems for Autonomy and Resilience with Krishna Sai [not-audio_url] [/not-audio_url]

Duration: 53:14
Enterprise IT systems have grown into sprawling, highly distributed environments spanning cloud infrastructure, applications, data platforms, and increasingly AI-driven workloads. Observability tools have made it easier…
Inside China’s Great Firewall with Jackson Sippe [not-audio_url] [/not-audio_url]

Duration: 58:40
China's Great Firewall is often spoken about but is rarely understood. It is one of the most sophisticated and opaque censorship systems on the planet, and it shapes how over a billion people interact with the global int…
Optimizing Agent Behavior in Production with Gideon Mendels [not-audio_url] [/not-audio_url]

Duration: 52:25
LLM -powered systems continue to move steadily into production, but this process is presenting teams with challenges that traditional software practices don't commonly encounter. Models and agents are non-deterministic s…