Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations

Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations podcast cover
Fexingo Technology

Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations

Lucas and Luna explore the landscape of database technology, from relational SQL systems to document-based NoSQL and emerging storage paradigms. Each episode examines a specific database model—columnar stores, graph databases, time-series engines, or serverless SQL—and dissects its architecture, performance characteristics, and real-world tradeoffs. Lucas brings a journalist's rigor, questioning vendor claims and surfacing benchmark data; Luna pushes back with practitioner experience, asking how these systems behave under production loads. Together they compare when PostgreSQL's mature indexing wins over MongoDB's flexible schema, or why Snowflake's cloud-native approach may not suit every analytical workload. The show also probes deeper: the economics of data storage, the rise of NewSQL, and the implications of data gravity. Listeners will walk away understanding not just which database to choose, but why one design philosophy beats another for a given problem. What happens when your application's read pattern shifts from row-based to columnar? How do you evaluate consistency models without oversimplifying? This is the conversation for data engineers, architects, and technical leaders who need to make informed storage decisions.

#SQL#NoSQL#DatabaseTech#DataStorage#PostgreSQL#MongoDB#Snowflake#TimeSeriesDB#GraphDatabase#ColumnarStorage#NewSQL#DataEngineering#Technology#FexingoBusiness#BusinessPodcast#DatabaseArchitecture#DataGravity#Benchmarking

Support Fexingo

Episodes

142 episodes

Why Database Autoincrement Keys Fail at Global Scale

Aug 1, 2026 · 8:23
0:000:00

Why Database Compression Uses Dictionary Encoding Not Run-Length

Jul 30, 2026 · 8:16
0:000:00

Why Database Recovery Needs ARIES Protocol

Jul 30, 2026 · 7:11
0:000:00

Why Database Serializable Snapshot Isolation Prevents Write Skew

Jul 29, 2026 · 6:29
0:000:00

Why Database Upsert Needs Merge Not Separate Insert or Update

Jul 29, 2026 · 6:39
0:000:00

Why Database Caching Needs a Write-Through Strategy

Jul 28, 2026 · 7:10
0:000:00

Why Write-Ahead Logging Is Critical for Database Durability

Jul 28, 2026 · 5:52
0:000:00

Why Database Partition Pruning Cuts Query Time Dramatically

Jul 27, 2026 · 9:28
0:000:00

Why Database Merge Joins Beat Hash Joins for Sorted Data

Jul 27, 2026 · 6:37
0:000:00

Why SQL Window Functions Outperform Self-Joins

Jul 26, 2026 · 7:05
0:000:00

Why Time-Series Data Needs Downsampling Not Raw Storage

Jul 26, 2026 · 8:04
0:000:00

Why Database Schema Changes Need Online Migration Not Downtime

Jul 25, 2026 · 8:14
0:000:00

Why Database Bloom Filters Defeat Expensive Disk Seeks

Jul 24, 2026 · 8:19
0:000:00

Why Database Cursor Fetching Needs Pagination Not Streaming

Jul 23, 2026 · 6:53
0:000:00

Why Database Deadlocks Need Wait-Die and Wound-Wait Schemes

Jul 23, 2026 · 11:13
0:000:00

Why Database Hybrid Transactional-Analytical Processing Matters

Jul 22, 2026 · 9:40
0:000:00

Why Database Query Routing Needs Read-Write Splitting

Jul 22, 2026 · 10:39
0:000:00

Why Database Sharding Fails Without a Consistent Hash Ring

Jul 21, 2026 · 8:11
0:000:00

Why Database Connection Timeouts Need Adaptive Retry Logic

Jul 21, 2026 · 8:18
0:000:00

Why Database Change Data Capture Needs Exactly-Once Semantics

Jul 20, 2026 · 8:29
0:000:00

Why Database Replication Needs Quorum Not Just Async

Jul 20, 2026 · 6:48
0:000:00

Why Database Vector Indexes Need Hierarchical Navigable Small Worlds

Jul 19, 2026 · 9:25
0:000:00

Why Database Compression Needs Dictionary Encoding Not Just Run-Length

Jul 19, 2026 · 12:22
0:000:00

Why Database Compaction Needs a Size-Tiered Strategy

Jul 18, 2026 · 8:37
0:000:00

Why Database Materialized Views Need Incremental Refresh

Jul 18, 2026 · 6:22
0:000:00

Why Database Indexing Needs Covering Indexes Not Just Indexes

Jul 17, 2026 · 10:50
0:000:00

Why Database Snapshot Isolation Breaks at Write Skew

Jul 17, 2026 · 7:43
0:000:00

Why Database Multi-Tenancy Needs Tenant Isolation Not Shared Tables

Jul 16, 2026 · 10:23
0:000:00

Why Database Row-Level Security Hurts Query Performance

Jul 16, 2026 · 5:11
0:000:00

Why Database Storage Engines Need Log-Structured Merge Trees

Jul 15, 2026 · 5:42
0:000:00

Why Database Query Plan Caching Backfires at Scale

Jul 15, 2026 · 7:10
0:000:00

Why Database JSON Schema Validation Costs You Performance

Jul 14, 2026 · 8:07
0:000:00

Why Database Connection Pool Sizing Needs Dynamic Scaling

Jul 14, 2026 · 10:35
0:000:00

Why Database Partition Pruning Fails Without Partition Elimination

Jul 13, 2026 · 9:00
0:000:00

Why Database Prepared Statements Prevent SQL Injection Not Just Performance

Jul 13, 2026 · 10:19
0:000:00

Why Database Caching Layers Need a Write-Aside Strategy

Jul 12, 2026 · 8:07
0:000:00

Why Database Indexes Fail Without Column Ordering

Jul 12, 2026 · 11:12
0:000:00

Why Your Database Needs Schema Versioning for Live Migrations

Jul 11, 2026 · 8:32
0:000:00

Why Database Query Routing Needs a Consistent Hash Ring

Jul 11, 2026 · 11:08
0:000:00

Why Database Vacuums Are Not a Maintenance Luxury

Jul 10, 2026 · 7:03
0:000:00

Why Database GEO Indexes Need Hilbert Curves Not Z-Order

Jul 10, 2026 · 10:30
0:000:00

Why Database Stored Procedures Need Function as a Service

Jul 9, 2026 · 8:31
0:000:00

Why Your Database Needs a Read-Through Cache Not Just a Write-Through One

Jul 9, 2026 · 10:19
0:000:00

Why Database Sharding Needs a Routing Layer Not a Hash

Jul 8, 2026 · 13:14
0:000:00

Why Database Time Travel Queries Are a Performance Trap

Jul 8, 2026 · 8:34
0:000:00

Why Database Connection Pool Sizing Needs Load Testing Not Formulas

Jul 7, 2026 · 10:55
0:000:00

Why Your Database Deadlines Fail Without Cost Layers

Jul 7, 2026 · 8:03
0:000:00

Why Database Query Plans Kill Your Performance Without Histograms

Jul 6, 2026 · 9:38
0:000:00

Why Database Audit Logs Fail Without Versioned Schemas

Jul 6, 2026 · 9:39
0:000:00

Why Database Connection Encryption Overhead Kills Latency SLA

Jul 5, 2026 · 10:32
0:000:00

Why Database Foreign Keys Cause Cascading Lock Contention

Jul 5, 2026 · 10:07
0:000:00

How Database Soft Deletes Cause Silent Data Corruption

Jul 4, 2026 · 8:36
0:000:00

Why Database Connection Pools Need Circuit Breakers

Jul 4, 2026 · 8:34
0:000:00

Why Your Database Needs a Query Router for Multi-Region Deployments

Jul 3, 2026 · 9:32
0:000:00

Why Database Materialized Views with Incremental Refresh Outperform Hand-Rolled Aggregates

Jul 3, 2026 · 9:16
0:000:00

Why Your Database Primary Key Should Be a UUIDv7

Jul 2, 2026 · 7:03
0:000:00

Why Database Shuffle Sort Is Killing Your Query Performance

Jul 2, 2026 · 8:49
0:000:00

Why Database Indexing on Timestamps Fails at High Throughput

Jul 1, 2026 · 9:55
0:000:00

Why Database Connection Pools Freeze Under Burst Traffic

Jul 1, 2026 · 10:40
0:000:00

How Database Materialized Views Accelerate Real-Time Analytics

Jun 30, 2026 · 6:24
0:000:00

Why Database Vector Search Requires Rethinking Indexes

Jun 30, 2026 · 9:56
0:000:00

Why Database Row-Level Security Creates Admin Nightmares

Jun 29, 2026 · 11:02
0:000:00

Why Database Connection Pool Starvation Still Happens in 2026

Jun 29, 2026 · 5:16
0:000:00

Why Database Schema Migrations Fail Without Feature Flags

Jun 28, 2026 · 8:14
0:000:00

Why Database Multi-Model Designs Are Gaining Traction

Jun 28, 2026 · 10:58
0:000:00

How Database Caching Layers Prevent Read Throughput Collapse

Jun 27, 2026 · 7:49
0:000:00

Why Database CDC Pipelines Break at Scale

Jun 27, 2026 · 7:58
0:000:00

Why Database Indexes on JSON Fields Fail in Production

Jun 26, 2026 · 6:58
0:000:00

Why Database Sharding Fails Without a Good Key Strategy

Jun 26, 2026 · 8:01
0:000:00

Why Database Columnar Storage Crushes Analytic Queries

Jun 25, 2026 · 10:36
0:000:00

Why Database Transaction Isolation Levels Confuse Developers

Jun 25, 2026 · 6:50
0:000:00

Why Database Query Execution Plans Sometimes Deceive You

Jun 24, 2026 · 8:29
0:000:00

How Database Virtualization Cuts Cloud Costs Without Refactoring

Jun 24, 2026 · 12:32
0:000:00

Why Database Connection Pool Starvation Is Still Happening in 2026

Jun 23, 2026 · 7:32
0:000:00

Why Database Storage Engines Matter for Performance

Jun 23, 2026 · 5:28
0:000:00

Why Database Connection Pool Starvation Still Happens in 2026

Jun 22, 2026 · 8:42
0:000:00

Why Database Connection Pool Starvation Still Happens in 2026

Jun 22, 2026 · 7:31
0:000:00

How Database Connection Pool Starvation Still Happens in 2026

Jun 21, 2026 · 10:09
0:000:00

Why Database Indexing on JSON Fields Fails in Production

Jun 21, 2026 · 8:20
0:000:00

Why Your Database Needs a Backup Verification Strategy

Jun 20, 2026 · 9:23
0:000:00

Why Database Connection Pool Size Tuning Still Matters in 2026

Jun 20, 2026 · 8:29
0:000:00

Why Database Collation Settings Break Multi-Language Search

Jun 19, 2026 · 10:17
0:000:00

Database Query Optimizer Hints When to Override and When to Trust

Jun 19, 2026 · 13:15
0:000:00

Why Your Database Needs a Time-Series Partitioning Strategy

Jun 18, 2026 · 8:10
0:000:00

Why Hybrid Transactional-Analytical Processing Is Winning

Jun 18, 2026 · 11:30
0:000:00

Why Your Database Needs a Read Replica Strategy

Jun 17, 2026 · 7:42
0:000:00

Why Database Caching Layer Design Prevents Costly Failures

Jun 17, 2026 · 7:40
0:000:00

Why Database Connection Refactoring Saves Millions

Jun 16, 2026 · 7:54
0:000:00

Why Database Cursor-Based Pagination Is Faster Than Offset

Jun 16, 2026 · 8:30
0:000:00

How Database Lock Contention Kills Concurrency

Jun 15, 2026 · 7:55
0:000:00

Why Your Database Needs a Schema Versioning Strategy

Jun 15, 2026 · 8:53
0:000:00

Why Your Database Triggers Are Slowing Everything Down

Jun 14, 2026 · 6:21
0:000:00

Why Database Sharding Still Works in 2026

Jun 14, 2026 · 8:58
0:000:00

Why Database Connection Pool Starvation Is Your Worst Nightmare

Jun 13, 2026 · 9:55
0:000:00

Why Database Time Zone Handling Breaks Queries

Jun 13, 2026 · 9:18
0:000:00

Why Row-Oriented Storage Wastes Your Database SSD

Jun 12, 2026 · 11:18
0:000:00

Why Database Connection Retry with Exponential Backoff Prevents Cascading Failures

Jun 12, 2026 · 8:47
0:000:00

Why Database NULL Values Destroy Query Performance

Jun 11, 2026 · 7:44
0:000:00

Why Database Partition Pruning Fails Without Careful Design

Jun 11, 2026 · 9:06
0:000:00

Why Database Column Compression Saves Millions

Jun 10, 2026 · 9:33
0:000:00

Why Database Connection Pool Size Tuning Still Matters in 2026

Jun 10, 2026 · 8:04
0:000:00

Why Database Materialized Views Outperform Regular Views

Jun 9, 2026 · 7:53
0:000:00

Why Your Database Needs a Concurrent Backup Strategy

Jun 9, 2026 · 7:42
0:000:00

Why Database Scaling Fails Without Query Analysis

Jun 8, 2026 · 7:31
0:000:00

Why Database Connectionless Architecture Is the Future

Jun 8, 2026 · 9:47
0:000:00

Why Database Stored Procedures Still Matter in 2026

Jun 7, 2026 · 10:36
0:000:00

Why Database Indexes Become a Performance Problem

Jun 7, 2026 · 8:06
0:000:00

Why Database Connection Latency Spikes Under Load

Jun 6, 2026 · 7:41
0:000:00

Why Database Caching Strategies Break Under Write-Heavy Workloads

Jun 6, 2026 · 7:27
0:000:00

Why Your Database Timeouts Are Silent Performance Killers

Jun 5, 2026 · 7:42
0:000:00

Why Database Views Leak Sensitive Data

Jun 5, 2026 · 9:15
0:000:00

Why Database Connection Pools Need Connection Validation

Jun 4, 2026 · 8:00
0:000:00

Why Database Connection Encryption Matters More Than You Think

Jun 4, 2026 · 1:07
0:000:00

Why Database Connection Pools Need Connection Validation

Jun 3, 2026 · 10:57
0:000:00

Why Database Read Replicas Break Your Queries

Jun 3, 2026 · 9:21
0:000:00

Why Your Database Needs a Connection Retry Strategy

Jun 2, 2026 · 7:54
0:000:00

Why Database Sharding Can Break Your Application

Jun 2, 2026 · 8:02
0:000:00

Why Database Connection Pools Need Pool Tuning Part Two

Jun 1, 2026 · 9:36
0:000:00

Why Database Connection Pools Need Pool Tuning

Jun 1, 2026 · 8:51
0:000:00

Why Database Connection Pools Need Pool Tuning

May 31, 2026 · 9:14
0:000:00

How Database Partitioning Prevents Performance Meltdowns

May 31, 2026 · 8:48
0:000:00

Why Database Connection Timeouts Are Dangerous

May 30, 2026 · 8:39
0:000:00

Why Database Materialized Views Fail Without Refresh Strategies

May 30, 2026 · 8:24
0:000:00

Why Your Data Warehouse Needs a Star Schema

May 29, 2026 · 10:05
0:000:00

How Query Caching Transforms Database Performance

May 29, 2026 · 10:39
0:000:00

How Connection Pooling Saves Your Database From Burst Traffic

May 28, 2026 · 8:03
0:000:00

Why Database Connection Pooling Fails Under Burst Traffic

May 28, 2026 · 9:04
0:000:00

Why Database Indexes Become Worse Than Useless

May 27, 2026 · 9:15
0:000:00

Why Database Connection Pools Crash Under Load

May 27, 2026 · 9:59
0:000:00

Why Database Migrations Fail Without Schema Versioning

May 26, 2026 · 9:25
0:000:00

Why Database Connection Pools Fail at Scale

May 26, 2026 · 13:02
0:000:00

Why Database Transactions Need Isolation Levels

May 25, 2026 · 10:23
0:000:00

Why Database Backups Fail Without Backup Validation

May 25, 2026 · 9:52
0:000:00

How Connection Pooling Prevents Database Meltdowns

May 24, 2026 · 8:36
0:000:00

Why Columnar Databases Crush Row Stores for Analytics

May 24, 2026 · 7:56
0:000:00

Why Read Replicas Fail at Peak Traffic

May 23, 2026 · 9:59
0:000:00

The Hidden Cost of Database Replication Lag

May 23, 2026 · 9:44
0:000:00

The CAP Theorem Tradeoff That Haunts Every Database Choice

May 22, 2026 · 6:30
0:000:00

How Write-Ahead Logs Protect Your Database Data

May 22, 2026 · 8:27
0:000:00

Why Database Sharding Breaks Without a Good Shard Key

May 21, 2026 · 8:41
0:000:00

Why Indexing Strategies Matter More Than Query Optimization

May 21, 2026 · 11:30
0:000:00

The Query That Cost a Startup 18 Hours

May 19, 2026 · 7:40
0:000:00