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

Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations is a business podcast hosted by Fexingo, with 155 episodes on record and a Required Pod Score of 80. PitchCentric scores this show on Booking Probability, Listen Score, and live audience signals refreshed every 24 hours.

Fexingo hosts Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations, a business show with 155 episodes published.

Our AI reads these to draft pitches. Use them as grounding for a pitch that cites a real guest and a specific topic.

• 

  Episode #160

  Why Database WAL Is the Unsung Hero of Durability

  Aug 19, 20269 minS4

  In this episode of Database Tech with Fexingo, Lucas and Luna unpack the write-ahead log (WAL) — the unsung hero of database durability. They explain why every modern database, from PostgreSQL to SQLite, relies on WAL to prevent data loss during crashes, how it works under the hood, and why it's not a silver bullet. Using a concrete example of a bank transfer and a sudden power outage, they illustrate how WAL ensures atomicity and durability without sacrificing performance. The episode also touches on the trade-offs of WAL, including the write amplification and the challenges of WAL archiving and replication. Listeners will come away with a clear understanding of why WAL is foundational to database reliability and how it enables features like point-in-time recovery. Perfect for developers, data engineers, and anyone curious about how databases keep their data safe. #WriteAheadLog #DatabaseDurability #PostgreSQL #SQLite #ARIES #DatabaseInternals #DataEngineering #CrashRecovery #TransactionLog #DatabaseReliability #StorageEngines #WAL #DatabaseTechnology #TechPodcast #FexingoBusiness #BusinessPodcast #DataStorage #DatabaseDesign Keep every episode free: buymeacoffee.com/fexingo

  ListenShow Notes
• 

  Episode #159

  Why Database Time Series Storage Uses Chunked Archives

  Aug 18, 202610 minS4

  In this episode of Database Tech with Fexingo, Lucas and Luna dig into the design of time-series databases and the chunked archive pattern that underpins systems like InfluxDB, Prometheus, and TimescaleDB. They explain why a flat table of timestamped rows performs poorly at scale, how chunking data by time interval improves write throughput and query speed, and how compression and retention policies become far simpler when data is organized in time-based blocks. The conversation anchors on a real-world example: a smart-meter deployment generating millions of readings per day, and why the database that handles it uses chunked archives rather than a traditional relational model. Along the way, they touch on downsampling, tiered storage, and the trade-off between write amplification and query granularity. A practical, example-driven look at why time-series databases structure data the way they do, and how that affects performance and cost. #TimeSeriesDatabase #ChunkedArchive #InfluxDB #Prometheus #TimescaleDB #IoTData #DatabaseDesign #DataCompression #RetentionPolicy #Downsampling #WriteThroughput #QueryPerformance #DatabaseStorage #TechPodcast #DataEngineering #FexingoBusiness #BusinessPodcast #DatabaseTech Keep every episode free: buymeacoffee.com/fexingo

  ListenShow Notes
• 

  Episode #158

  Why Database Migrations Need Expansion and Contraction

  Aug 17, 20268 minS4

  Database schema changes are inevitable, but altering a live table with millions of rows can lock it for hours and take down your service. In this episode, Lucas and Luna dive into the expand-and-contract pattern, the technique that lets teams change schemas without downtime by running dual writes, backfilling, and switching reads in phases. They walk through a real-world example: a checkout table in an e-commerce system moving from one address column to separate fields, showing how each step keeps the system available and consistent. They also discuss why tools like gh-ost and pt-online-schema-change exist, what happens when you skip the backfill, and why the migration itself is the easy part while the coordination is the hard part. If you've ever dreaded a big ALTER TABLE, this episode gives you a concrete playbook to do it safely. #DatabaseMigrations #ExpandAndContract #SchemaChange #ZeroDowntime #OnlineSchemaChange #DualWrites #Backfill #DatabaseEngineering #SQL #NoSQL #DataStorage #TechPodcast #FexingoBusiness #BusinessPodcast #DataEngineering #SoftwareArchitecture #ghost #ptosc Keep every episode free: buymeacoffee.com/fexingo

  ListenShow Notes
• 

  Episode #157

  Why Database Vectors Need HNSW Indexes

  Aug 16, 20268 minS4

  In this episode of Database Tech with Fexingo, Lucas and Luna unpack Hierarchical Navigable Small World (HNSW) indexes—the engine behind modern vector search. They start with a real-world latency problem at a music recommendation startup, then explain why brute-force similarity search collapses at scale. With a whiteboard-style breakdown, they reveal how HNSW builds multi-layer graphs to navigate high-dimensional spaces in logarithmic time. They contrast HNSW with inverted file indexes and product quantization, showing why each exists and when to choose one over the other. Along the way, they discuss the cost of index maintenance, the tradeoff between recall and speed, and how memory constraints shape real deployments. By the end, you'll understand why HNSW is the default for vector databases like Pinecone and Weaviate, and you'll be able to explain its 'six degrees of separation' trick to a friend. No prior graph theory needed—just curiosity about how machines search through millions of embeddings in milliseconds. #HNSW #VectorSearch #DatabaseIndexing #SimilaritySearch #HighDimensionalData #MachineLearning #DataEngineering #Technology #NoSQL #GraphAlgorithms #Pinecone #Weaviate #Embeddings #NearestNeighbor #Performance #FexingoBusiness #BusinessPodcast #DatabaseTech Keep every episode free: buymeacoffee.com/fexingo

  ListenShow Notes
• 

  Episode #156

  Why Database Connections Need Multiplexing Not Pools

  Aug 15, 202611 minS4

  Connection pooling is the standard fix for database connection overhead, but under burst load, pools themselves become the bottleneck. In this episode, Lucas and Luna dig into multiplexing—why streaming a single connection across many requests can outperform a pool, how PostgreSQL and MySQL handle it differently, and what happens when a bank's payment service hit a connection ceiling on a Black Friday. They break down the mechanics of multiplexing, the trade-offs with transactions and prepared statements, and when you should actually reach for it. If you've ever watched connection wait times spike while CPU idles, this one's for you. #DatabaseConnections #Multiplexing #ConnectionPooling #PostgreSQL #MySQL #PgBouncer #ProxySQL #DatabasePerformance #BackendEngineering #Tech #FexingoBusiness #BusinessPodcast #DataEngineering #Scalability #DatabaseScaling #ConnectionManagement #DatabaseInternals #SoftwareArchitecture Keep every episode free: buymeacoffee.com/fexingo

  ListenShow Notes

Based on semantic analysis of episode topics and host coverage, this show is a strong guest fit for executives in:

Industry fit is computed by PitchCentric using vector embeddings of the show's episode catalog.