エピソード

  • Why Database Connectionless Architecture Is the Future

    Why Database Connectionless Architecture Is the Future
    2026/06/08
    In Episode 38 of Database Tech with Fexingo, Lucas and Luna explore the emerging concept of connectionless database architectures. Using CockroachDB and Google Cloud Spanner as concrete examples, they explain how eliminating persistent TCP connections can reduce latency, improve scalability, and simplify connection management for modern distributed systems. The hosts discuss the HTTP/gRPC-based request model, compare it to traditional connection pooling, and weigh the trade-offs in consistency and complexity. A must-listen for engineers evaluating next-gen database designs. #ConnectionlessArchitecture #CockroachDB #GoogleCloudSpanner #DatabaseDesign #DistributedSystems #HTTP #gRPC #ConnectionPooling #Scalability #Latency #TechPodcast #DatabaseTech #SQL #NoSQL #DataStorage #Engineering #FexingoBusiness #BusinessPodcast Keep every episode free: buymeacoffee.com/fexingo
    続きを読む 一部表示
    10 分
  • Why Database Stored Procedures Still Matter in 2026

    Why Database Stored Procedures Still Matter in 2026
    2026/06/07
    In this episode of Database Tech with Fexingo, Lucas and Luna explore why stored procedures—once considered legacy—are seeing a resurgence in modern cloud databases. They break down a real-world case from a mid-sized e-commerce company that cut query latency by 40 percent by moving critical order-processing logic into stored procedures. The discussion covers when to use them, the trade-offs with application-layer logic, and why the rise of serverless and edge computing is changing the calculus. No fluff, just a concrete look at a forgotten tool that still delivers. Perfect for engineers and architects evaluating database design patterns in 2026. #StoredProcedures #Database #SQL #Tech #Technology #DatabaseTech #FexingoBusiness #BusinessPodcast #CloudDatabases #Serverless #EdgeComputing #QueryPerformance #EcommerceTech #DatabaseOptimization #LegacyTech #SoftwareEngineering #DataArchitecture #DatabaseDesign Keep every episode free: buymeacoffee.com/fexingo
    続きを読む 一部表示
    11 分
  • Why Database Indexes Become a Performance Problem

    Why Database Indexes Become a Performance Problem
    2026/06/07
    Lucas and Luna explore a counterintuitive database performance issue: indexes that actually slow queries down. They examine how B-tree index depth grows with data volume, turning fast lookups into multi-level tree traversals. The discussion uses a concrete example of a 10-million-row table on PostgreSQL and shows how a poorly chosen composite index on an e-commerce orders table caused query times to jump from 2 milliseconds to over 200 milliseconds after a schema migration. They explain index fragmentation, the impact of high-cardinality columns, and why write-heavy workloads suffer from index maintenance overhead. Practical tuning advice includes using pg_stat_user_indexes to spot unused indexes and considering partial indexes for skewed data distributions. The episode closes with a reminder that indexes are not set-and-forget—they need periodic review. #DatabaseIndexes #PostgreSQL #BTree #QueryPerformance #IndexTuning #DatabaseOptimization #CompositeIndex #IndexFragmentation #Cardinality #PartialIndex #pg_stat_user_indexes #WriteHeavyWorkloads #Technology #DatabaseTech #FexingoBusiness #BusinessPodcast #SQL #DataStorage Keep every episode free: buymeacoffee.com/fexingo
    続きを読む 一部表示
    8 分
  • Why Database Connection Latency Spikes Under Load

    Why Database Connection Latency Spikes Under Load
    2026/06/06
    Lucas and Luna explore why database connection latency can suddenly spike from 2 milliseconds to over 200 milliseconds under heavy load, even when the database itself isn't saturated. They examine a real-world case from a mid-sized e-commerce platform where connection establishment overhead — TCP handshakes, TLS negotiation, authentication — became the bottleneck after a routine deployment. Lucas explains how connection pooling mitigates this but why pool size tuning and keepalive settings matter more than most engineers realize. Luna challenges the common assumption that adding more connections helps, revealing how connection storms can cascade into latency disasters. The episode covers specific tools like pgBouncer for PostgreSQL, connection multiplexing strategies, and why monitoring connection establishment time is more important than query execution time for many applications. A practical deep dive for anyone who has ever seen application latency degrade without obvious database performance issues. #Database #Technology #ConnectionLatency #PostgreSQL #pgBouncer #ConnectionPooling #TCPHandshake #TLSNegotiation #DatabasePerformance #LatencySpikes #ConnectionStorm #BackendEngineering #SQL #NoSQL #DataEngineering #FexingoBusiness #BusinessPodcast #TechPodcast Keep every episode free: buymeacoffee.com/fexingo
    続きを読む 一部表示
    8 分
  • Why Database Caching Strategies Break Under Write-Heavy Workloads

    Why Database Caching Strategies Break Under Write-Heavy Workloads
    2026/06/06
    On this episode of Database Tech with Fexingo, Lucas and Luna dig into why caching — a go-to performance fix — can actually harm your database under write-heavy workloads. They break down the invalidation problem using a concrete example: a social media platform tracking daily active users. Lucas explains how a naive time-to-live cache can return stale data for hours, while Luna pushes back on the common 'just use Redis' mindset. They explore cache-aside, write-through, and write-back strategies, revealing why the latter introduces serious crash risks. The hosts also tie the discussion to real-world trade-offs at companies like Uber and Twitter, where read-heavy vs. write-heavy patterns demand totally different caching architectures. No ad break, no fluff — just a focused 10-minute conversation on one specific database design decision that can make or break application performance. #Database #Caching #WriteHeavyWorkloads #CacheInvalidation #CacheAside #WriteThrough #WriteBack #Redis #TimeToLive #DatabasePerformance #DataEngineering #TechPodcast #FexingoBusiness #BusinessPodcast #DatabaseTech #SQL #NoSQL #LucasAndLuna Keep every episode free: buymeacoffee.com/fexingo
    続きを読む 一部表示
    7 分
  • Why Your Database Timeouts Are Silent Performance Killers

    Why Your Database Timeouts Are Silent Performance Killers
    2026/06/05
    In this episode of Database Tech with Fexingo, Lucas and Luna dive into the hidden costs of database timeouts—specifically, why the default timeout values in most application frameworks are dangerously high. Using a real-world case from a mid-sized e-commerce company that saw a 40% drop in checkout completion after a traffic spike, they explain how timeouts compound under load, how to calculate the right timeout for your workload, and why connection pool exhaustion often gets misdiagnosed as a database bottleneck. No fluff, just actionable guidance for developers and ops teams who need their databases to survive Black Friday without falling over. #DatabaseTimeouts #ConnectionPooling #BackendPerformance #PostgreSQL #MySQL #NodeJS #Golang #EcommerceTech #BlackFriday #DatabaseBestPractices #SoftwareEngineering #TechOps #PerformanceTuning #RelationalDatabases #FexingoBusiness #BusinessPodcast #TechPodcast #DatabaseTech Keep every episode free: buymeacoffee.com/fexingo
    続きを読む 一部表示
    8 分
  • Why Database Views Leak Sensitive Data

    Why Database Views Leak Sensitive Data
    2026/06/05
    Episode 32 of Database Tech with Fexingo. Lucas and Luna uncover a subtle but dangerous database vulnerability: security views that accidentally expose sensitive columns like passwords or SSNs through simple tricks like casting to text or selecting via star. Drawing on a real 2023 incident where a Fortune 500 company leaked 50,000 customer records through a poorly designed view, they explain how PostgreSQL's information_schema.columns can reveal hidden columns, why WITH CHECK OPTION isn't a security feature, and the concrete steps—like explicit column lists, column-level privileges, and output masking—that prevent leaks. Perfect for developers and DBAs who think a secure view is just a WHERE clause. #DatabaseSecurity #SQLViews #PostgreSQL #DataLeak #ColumnPrivileges #InformationSchema #SecureViews #WITHCHECKOPTION #OutputMasking #RowLevelSecurity #Fortune500Breach #DatabaseTech #Technology #FexingoBusiness #BusinessPodcast #LucasAndLuna #DataEngineering #SecurityVulnerability Keep every episode free: buymeacoffee.com/fexingo
    続きを読む 一部表示
    9 分
  • Why Database Connection Pools Need Connection Validation

    Why Database Connection Pools Need Connection Validation
    2026/06/04
    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
    続きを読む 一部表示
    8 分