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

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

Fexingo
Postgresql
Mysql
Sharding
Connection Pooling
Consistent Hashing
Redis
Cassandra
Bloom Filter
SQL Server
Replication Lag
Connection Pool
Caching
LSM Tree
Schema Versioning
Read Replicas
Cockroachdb
Indexing
Google Spanner
Mongodb
Snapshot Isolation

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 v... more

PublishesDailyEpisodes149Founded3 months ago
Number of ListenersCategory
Business

Listen to this Podcast

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

Latest Episodes

Episode 149 of Database Tech with Fexingo drills into the hidden cost of missing statistics. Hosts Lucas and Luna explain why database query optimizers rely on histograms to estimate row counts — and what happens when those estimates are stale or mis... more

Lucas and Luna dive into the hidden role of histograms in database query planning. When PostgreSQL's planner assumes uniform data distribution, it can pick a disastrously slow plan — like choosing a nested loop join against a table with millions of r... more

In this episode of Database Tech with Fexingo, Lucas and Luna explore the role of sparse indexes in database performance, contrasting them with dense indexes and explaining why they are a critical tool for large-scale data retrieval. Using the exampl... more

When a database outgrows a single machine, sharding spreads data across clusters — but naive range-based sharding concentrates hot spots and makes resharding a nightmare. In this episode, Lucas and Luna break down why consistent hashing, not simple m... more

In Episode 145 of Database Tech with Fexingo, Lucas and Luna dive into the hidden costs of false positives in database Bloom filters. They explore how a classic space-saving optimization can backfire when filter parameters are tuned wrong, using a re... more

In this episode of Database Tech with Fexingo, Lucas and Luna dive into multiversion concurrency control, the technique that lets Postgres and other databases run reads and writes simultaneously without stepping on each other. They explain why snapsh... more

In this episode of Database Tech with Fexingo, Lucas and Luna tackle a problem every database engineer has hit: you write a record, then read it back, and it's not there. That's replication lag, and it can break the read-your-writes consistency your ... more

Lucas and Luna dive into the hidden fragility of autoincrement primary keys when databases scale horizontally. They use the concrete example of a social platform that hit a key collision after sharding, explaining why the classic INTEGER AUTOINCREMEN... more

Key Facts

Accepts Sponsors
Contact Information
Podcast Host
Number of Listeners
Find out how many people listen to this podcast per episode and each month.

Hosts

Lucas
Host of Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations
Luna
Co-host pushing practitioner experience and production loads

Chart Rankings

How this podcast ranks in the Apple Podcasts, Spotify and YouTube charts.

Apple Podcasts
#166
South Korea/Business
Apple Podcasts
#214
Brazil/Business

Talking Points

Recent interactions between the hosts and their guests.

Why Database Query Plan Caching Backfires at Scale
Q: What about prepared statements? Do they suffer from the same caching issues?
Yes, prepared statements in PostgreSQL are cached at the session level and can exhibit the same skew or suboptimal plans as generic cached plans; the trade-off is between stability and peak performance, with the optimizer often using average selectivity for safety.
Why Database Query Plan Caching Backfires at Scale
Q: So, what's the practical takeaway? If I'm a developer, should I disable plan caching?
Don't disable plan caching globally; instead monitor the plan cache hit ratio and identify queries with high average execution time relative to their initial run, then consider query hints or plan guides for those critical cases.
Why Database Vector Search Requires Rethinking Indexes
Q: Can you walk through what exactly broke in their setup?
The team used a vector database that supported pre-filtering, applying scalar filters before a vector search. This worked in theory, but in practice the vector index is designed to search the entire dataset; limiting it to a small, unpredictable subset degraded the approximation quality and caused missed relevant results, revealing that per-subset indexing requires architecture redesign rather than a simple switch.

Audience Metrics

Listeners, social reach, demographics and more for this podcast.

Listeners per Episode
Gender Skew
Location
Interests
Professions
Age Range
Household Income
Social Media Reach

Frequently Asked Questions About This Podcast

What is This Podcast about and what kind of topics does it cover?

The show delivers practitioner-focused discussions around database technologies, comparing SQL, NoSQL, and emerging storage paradigms through deep dives into architecture, performance characteristics, and real-world tradeoffs. Episodes frequently center on topics like indexing strategies, caching, connection pooling, replication, and migration workflows, often anchoring concepts with concrete, production-oriented examples and quantified results. A standout pattern is the rigorous, hands-on interrogation of vendor claims and design decisions, paired with back-and-forth questions that push for practical implications under real workloads. This combination—clear explanations, concrete numbers, and production perspective—helps listeners decide n... more

Where can I find podcast stats for this podcast?

Rephonic provides a wide range of podcast stats for this podcast. We scanned the web and collated all of the information that we could find in our comprehensive podcast database. See how many people listen to this podcast and access YouTube viewership numbers, download stats, audience demographics, chart rankings, ratings, reviews and more.

How many listeners does this podcast get?

Rephonic provides a full set of podcast information for three million podcasts, including the number of listeners. View further listenership figures for this podcast, including podcast download numbers and subscriber numbers, so you can make better decisions about which podcasts to sponsor or be a guest on. You will need to upgrade your account to access this premium data.

What are the audience demographics for this podcast?

Rephonic provides comprehensive predictive audience data for this podcast, including gender skew, age, country, political leaning, income, professions, education level, and interests. You can access these listener demographics by upgrading your account.

How many subscribers and views does this podcast have?

To see how many followers or subscribers this podcast has on Spotify and other platforms such as Castbox and Podcast Addict, simply upgrade your account. You'll also find viewership figures for their YouTube channel if they have one.

How many episodes of this podcast are there?

this podcast launched 3 months ago and published 149 episodes to date. You can find more information about this podcast including rankings, audience demographics and engagement in our podcast database.

How do I contact this podcast?

Our systems regularly scour the web to find email addresses and social media links for this podcast. We scanned the web and collated all of the contact information that we could find in our podcast database. But in the unlikely event that you can't find what you're looking for, our concierge service lets you request our research team to source better contacts for you.

Where can I see ratings and reviews for this podcast?

Rephonic pulls ratings and reviews for this podcast from multiple sources, including Spotify, Apple Podcasts, Castbox, and Podcast Addict.

View all the reviews in one place instead of visiting each platform individually and use this information to decide if a show is worth pitching or not.

How do I access podcast episode transcripts for this podcast?

Rephonic provides full transcripts for episodes of this podcast. Search within each transcript for your keywords, whether they be topics, brands or people, and figure out if it's worth pitching as a guest or sponsor. You can even set-up alerts to get notified when your keywords are mentioned.

Find and pitch the right podcasts

We help savvy brands, marketers and PR professionals to find the right podcasts for any topic or niche. Get the data and contacts you need to pitch podcasts at scale and turn listeners into customers.
Try it free for 7 days