Database Architecture Podcast Summaries

Database Architecture on Yedapo: 3 summarized podcast and YouTube episodes. Each includes key takeaways, core concepts and notable quotes with timestamps.

Kenapa Koneksi PostgreSQL Itu Mahal?
Programmer Zaman Now
Jun 17, 2026
Koneksi PostgreSQL bersifat mahal karena setiap klien membutuhkan proses OS terpisah. Saat menggunakan connection pooler seperti PgBouncer dalam 'transaction mode', penggunaan 'prepared statements' menyebabkan eksekusi query gagal secara acak karena koneksi yang berganti-ganti. Strategi ini krusial bagi arsitektur serverless yang membutuhkan efisiensi koneksi tinggi.
Key insight: Bug 404 pada data yang baru di-insert seringkali disebabkan oleh 'prepared statement' yang tidak ditemukan di koneksi baru saat PgBouncer melakukan pooling dalam transaction mode.
RAG Just Got Inverted. Here's The Stack That Replaces It.
The AI Automators
May 25, 2026
Redis has launched Iris, a new architecture designed to solve the 'runtime' bottleneck in AI agents. By prioritizing fresh, high-speed data synchronization over static pre-compiled knowledge layers, Iris enables agents to navigate rapidly changing operational data in production environments.
Key insight: Redis Iris uses change data capture (CDC) to mirror operational databases in real-time, allowing agents to query live data rather than stale, pre-computed artifacts.
Trouble Creating a view in MySQL
Roel Van de Paar
Mar 26, 2026
Roel VandePaar delivers a surgical solution to the persistent syntax errors that block MySQL view creation. By leveraging insights from elite Stack Overflow engineers, he simplifies complex database schema troubleshooting into an actionable fix.
Key insight: Creating views in MySQL often fails due to specific syntax misalignments and permission conflicts that even seasoned developers overlook during schema design.