Episodes

  • Why Database Connection Pool Starvation Still Happens in 2026

    Why Database Connection Pool Starvation Still Happens in 2026
    Jun 29 2026
    Even in 2026, database connection pool starvation remains a top production issue. Lucas and Luna revisit why connection pool exhaustion still occurs despite years of best practices, using a real-world example from a mid-sized e-commerce platform that saw cascading failures during a flash sale. They explain the two most common root causes: too-small pools and long-running queries holding connections, and discuss practical fixes like connection timeout tuning, pool monitoring, and query optimization. This episode is a must-listen for back-end engineers and DevOps teams dealing with scaling databases. #DatabaseConnectionPool #ConnectionStarvation #DatabasePerformance #BackendEngineering #DevOps #ScalingDatabases #SQLErrors #ConnectionTimeout #QueryOptimization #EcommerceTech #DatabaseTroubleshooting #TechPodcast #DatabaseTech #FexingoBusiness #BusinessPodcast #2026 #ProductionIssues #DataEngineering Keep every episode free: buymeacoffee.com/fexingo
    Show More Show Less
    5 mins
  • Why Database Schema Migrations Fail Without Feature Flags

    Why Database Schema Migrations Fail Without Feature Flags
    Jun 28 2026
    Lucas and Luna discuss a painful production outage at a fintech company caused by a database schema migration that ran before the application code was ready. They explain how feature flags can decouple deployment from release, the risks of online DDL tools in high-traffic systems, and why many teams still treat migrations as an afterthought. Specific numbers: 47-minute write lock, 12 terabytes of data, 3.2 million transactions per minute. A practical episode for engineers who want to sleep better on deployment nights. #Database #SchemaMigration #FeatureFlags #OnlineDDL #Fintech #ProductionIncident #WriteLock #DatabaseDesign #DevOps #ControlledDeployment #DataEngineering #Technology #FexingoBusiness #BusinessPodcast #LucasAndLuna #DatabaseBestPractices #MigrationStrategy #ReleaseManagement Keep every episode free: buymeacoffee.com/fexingo
    Show More Show Less
    8 mins
  • Why Database Multi-Model Designs Are Gaining Traction

    Why Database Multi-Model Designs Are Gaining Traction
    Jun 28 2026
    Lucas and Luna explore why a growing number of organizations are adopting multi-model databases—systems that natively support relational, document, graph, and key-value workloads in a single engine. They examine the driving forces: the rise of polyglot persistence fatigue, the cost savings from eliminating multiple database stacks, and the practical trade-offs in query performance and operational complexity. The episode centers on a case study of a mid-sized e-commerce company that consolidated its data layer from four separate databases into one multi-model system running ArangoDB, cutting infrastructure costs by 40% while maintaining sub-50 millisecond query latencies for 90% of their workloads. Lucas explains how the technology has matured since the early days of MongoDB and Couchbase, and Luna presses on where single-model specialists still outperform. They close by discussing when a multi-model approach makes sense—and when it's a trap. #MultiModelDatabase #ArangoDB #PolyglotPersistence #DatabaseConsolidation #NoSQL #GraphDatabase #DocumentStore #KeyValueStore #InfrastructureCost #QueryPerformance #Technology #DataEngineering #CloudMigration #DatabaseArchitecture #FexingoBusiness #BusinessPodcast #TechTrends2026 #DataStorage Keep every episode free: buymeacoffee.com/fexingo
    Show More Show Less
    11 mins
  • How Database Caching Layers Prevent Read Throughput Collapse

    How Database Caching Layers Prevent Read Throughput Collapse
    Jun 27 2026
    Lucas and Luna explore why database caching layers are essential for preventing read throughput collapse under heavy load, using a real-world example from a mid-sized e-commerce platform that saw query latency spike from 12ms to over 2 seconds during a flash sale. They break down caching strategies including write-through, write-behind, and cache-aside patterns, and explain how a poorly configured Redis cluster made things worse before it got better. Perfect for developers and architects dealing with high-read workloads. #DatabaseCaching #Redis #ReadThroughput #CacheAside #WriteThrough #WriteBehind #Ecommerce #FlashSale #Latency #QueryPerformance #DataEngineering #TechPodcast #DatabaseTech #FexingoBusiness #BusinessPodcast #SQL #NoSQL #PerformanceTuning Keep every episode free: buymeacoffee.com/fexingo
    Show More Show Less
    8 mins
  • Why Database CDC Pipelines Break at Scale

    Why Database CDC Pipelines Break at Scale
    Jun 27 2026
    Change Data Capture (CDC) pipelines are the backbone of modern real-time data architectures, but they often fail in production when event volume spikes or schema changes silently. Lucas and Luna walk through a real-world case from a mid-2026 fintech outage: a CDC pipeline that missed 12% of transactions during a flash sale because of unbounded log retention and missing idempotency keys. They explain the three most common failure modes—log truncation, schema drift, and backpressure stalls—and how to design for resilience. If you use Debezium, Kafka Connect, or any CDC tooling, this episode gives you concrete patterns to avoid waking up to a lagging pipeline at 3 AM. #ChangeDataCapture #CDC #DatabasePipelines #RealTimeData #KafkaConnect #Debezium #SchemaDrift #LogTruncation #Backpressure #FintechOutage #DataEngineering #StreamingData #Idempotency #DatabaseLogs #Technology #FexingoBusiness #BusinessPodcast #DatabaseTech Keep every episode free: buymeacoffee.com/fexingo
    Show More Show Less
    8 mins
  • Why Database Indexes on JSON Fields Fail in Production

    Why Database Indexes on JSON Fields Fail in Production
    Jun 26 2026
    Lucas and Luna dig into a subtle database pitfall: indexing JSON fields inside Postgres and MySQL. They walk through a real production case where a developer added a GIN index on a JSONB column, only to find query times actually increased for certain lookup patterns. The problem: JSON indexes don't behave like simple B-tree indexes; they store the entire JSON structure, and queries that don't use the right operators or that touch only a few keys can still trigger full scans. Lucas explains the difference between GIN and B-tree indexes, the role of JSON path operators, and why the query planner sometimes chooses a sequential scan even with an index present. Luna brings up a practical example from an e-commerce catalog where millions of rows with JSON attributes caused mysterious slowdowns. They also discuss alternatives: extracted generated columns, partial indexes, and when it's better to normalize the JSON keys into separate columns. The takeaway: JSON indexes can help, but only if you understand the query patterns and index types involved. Otherwise, they add overhead without benefit. #JSONIndexing #PostgreSQL #MySQL #GIN #BTree #QueryOptimization #DatabasePerformance #IndexDesign #GeneratedColumns #PartialIndex #Normalization #Ecommerce #ProductionDebug #Technology #DataEngineering #FexingoBusiness #BusinessPodcast #DatabaseTech Keep every episode free: buymeacoffee.com/fexingo
    Show More Show Less
    7 mins
  • Why Database Sharding Fails Without a Good Key Strategy

    Why Database Sharding Fails Without a Good Key Strategy
    Jun 26 2026
    Sharding is supposed to make databases infinitely scalable, but choosing the wrong shard key can destroy performance. Lucas and Luna dig into a real case: a mid-size SaaS company that sharded their user table by customer ID, only to see one shard handle 90% of the traffic because their biggest client's users logged in at the same time. They walk through how hash-based keys, composite keys, and lookup tables solve this, and why database sharding without a key strategy is just distributed pain. Perfect for engineers and architects wrestling with scale. #DatabaseSharding #ShardKey #Scalability #PostgreSQL #MySQL #DistributedSystems #DatabaseDesign #HashSharding #CompositeKey #LookupTable #ShardAwareRouting #DataArchitecture #SaaS #DatabasePerformance #Engineering #Tech #FexingoBusiness #BusinessPodcast Keep every episode free: buymeacoffee.com/fexingo
    Show More Show Less
    8 mins
  • Why Database Columnar Storage Crushes Analytic Queries

    Why Database Columnar Storage Crushes Analytic Queries
    Jun 25 2026
    Lucas and Luna dive into why database columnar storage formats like Parquet and ORC have become essential for analytic workloads, especially in cloud environments. They explore how columnar storage differs from row-based storage, using concrete examples from Amazon Redshift and Google BigQuery. The episode walks through compression benefits, predicate pushdown, and how choosing the right format can reduce query times from minutes to seconds. Luna challenges the notion that columnar storage is always superior, and Lucas explains when row-based still wins. They also touch on how DuckDB and ClickHouse are pushing columnar storage further, and what this means for developers building data pipelines in mid-2026. #ColumnarStorage #DatabaseTechnology #Parquet #ORC #AmazonRedshift #GoogleBigQuery #DuckDB #ClickHouse #AnalyticQueries #DataPipelines #QueryOptimization #Compression #PredicatePushdown #CloudComputing #BigData #DataEngineering #FexingoBusiness #BusinessPodcast Keep every episode free: buymeacoffee.com/fexingo
    Show More Show Less
    11 mins