EPISODE · Jun 4, 2026 · 8 MIN
Why Database Connection Pools Need Connection Validation
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations · host Fexingo
Episode 31 of Database Tech with Fexingo dives into connection validation — the silent killer of production databases. Lucas and Luna explore why a PostgreSQL pool at a mid-sized e-commerce company crashed during Black Friday, how a single 'SELECT 1' health check could have prevented it, and why many teams skip validation until it's too late. They break down the difference between idle-in-transaction timeouts, TCP keepalives, and application-level validation, with concrete numbers on latency trade-offs. If you've ever seen a 'connection reset' error and wondered why, this episode has answers. Plus, a quick note on how listener support keeps the show ad-free — at buy-me-a-coffee dot com slash fexingo. #DatabaseConnectionPools #ConnectionValidation #PostgreSQL #MySQL #BackendEngineering #DatabasePerformance #NodeJS #Python #Java #PostgreSQLConnectionPool #PgBouncer #HikariCP #ConnectionPoolTuning #DatabaseHealthChecks #ProductionDatabase #BackendInfrastructure #FexingoBusiness #TechnologyPodcast Keep every episode free: buymeacoffee.com/fexingo
What this episode covers
Episode 31 of Database Tech with Fexingo dives into connection validation — the silent killer of production databases. Lucas and Luna explore why a PostgreSQL pool at a mid-sized e-commerce company crashed during Black Friday, how a single 'SELECT 1' health check could have prevented it, and why many teams skip validation until it's too late. They break down the difference between idle-in-transaction timeouts, TCP keepalives, and application-level validation, with concrete numbers on latency trade-offs. If you've ever seen a 'connection reset' error and wondered why, this episode has answers. Plus, a quick note on how listener support keeps the show ad-free — at buy-me-a-coffee dot com slash fexingo. #DatabaseConnectionPools #ConnectionValidation #PostgreSQL #MySQL #BackendEngineering #DatabasePerformance #NodeJS #Python #Java #PostgreSQLConnectionPool #PgBouncer #HikariCP #ConnectionPoolTuning #DatabaseHealthChecks #ProductionDatabase #BackendInfrastructure #FexingoBusiness #TechnologyPodcast Keep every episode free: buymeacoffee.com/fexingo
NOW PLAYING
Why Database Connection Pools Need Connection Validation
No transcript for this episode yet
Similar Episodes
Mar 26, 2026 ·1m
Mar 19, 2026 ·34m
Feb 18, 2026 ·11m
Feb 11, 2026 ·45m