Databases
78 episodes · Page 3 of 4
#2105: The Hidden 2006 Inflection Point of ERP
Before cloud and AI, ERPs were the unglamorous engines running global business. Here's how they worked in 2006.
#1944: PostgreSQL: The Thirty-Year Miracle
How does a volunteer-run database power the New York Stock Exchange and survive every tech trend without burning out?
#1938: JSON-to-SQL Type Mapping: A Practical Guide
Mapping JSON to SQL isn't as simple as it looks. Discover the hidden traps in data types that can cause performance hits and data corruption.
#1925: The Plumbing That Keeps Science From Collapsing
Half of all links in academic papers are dead. Here’s the plumbing that keeps knowledge from vanishing.
#1920: InfluxDB vs. Postgres: The Time-Series Showdown
We compare specialized time-series databases like InfluxDB against traditional SQL options like Postgres with Timescale extensions.
#1838: Tuning Search Without Losing Your Mind
Modern search bars are AI decision engines. Here's how small teams can tune fuzzy matching, semantic search, and reranking without breaking everyth...
#1764: Your Repo as a Knowledge Base
How to give AI agents instant memory of your entire project—without cloud costs or complex infrastructure.
#1506: The Apache Way: Powering the Global Digital Backbone
Explore how the Apache Software Foundation governs the world's most critical data tools and why "Community Over Code" is the secret to its success.
#1505: Why Columnar Databases Crush Row-Based for Big Data
Discover how Google BigQuery and the GDELT project allow researchers to analyze billions of global news records using real-time AI and SQL.
#1483: The Recall-Per-Dollar Era: Mastering Vector Database Tuning
Stop burning money on unoptimized vector searches. We dive into HNSW tuning, distance metrics, and the vital "recall-per-dollar" metric.
#1475: The Folder Illusion: Why Cloud Storage Breaks Your Mental Model
Folders are a lie in the cloud. Explore why Amazon S3 uses flat namespaces and "keys" instead of traditional file hierarchies.
#1237: Ghost Flights and Legacy Code: Why Travel Tech is Broken
Ever wondered why that flight vanished while booking? Explore the 1960s mainframes and cryptic protocols holding the travel industry together.
#1233: Why "Just Use Postgres" Isn't Always Enough
Can one database do it all? Explore why hardware constraints and data geometry keep specialized databases like Snowflake and ClickHouse alive.
#1226: The Polyglot Shift: Why Python is Losing Ground
Python’s market share is dipping. Discover why R and Julia are making a massive comeback in high-stakes data science and scientific research.
#1221: Beyond Migrations: Breaking the SQL Straitjacket with AI
Stop writing manual SQL migrations. Explore how AI agents are transforming the database from a rigid "straitjacket" into a flexible, evolving state.
#1220: Why You Can't Give an AI the Database Password
Why can't we just give AI the database password? Explore the shift from REST to GraphQL and how the Model Context Protocol changes the game.
#1215: The Vector DB Hangover: Scaling Without Going Broke
Stop overpaying for your AI's memory. We break down the math of self-hosting vectors and the rise of serverless search.
#1213: Is Your JSON Store Just a Postgres Feature Now?
Explore why the NoSQL revolution didn't kill SQL and how document databases are finding a new second life in the era of AI and RAG pipelines.
#1212: The Postgres Vector Revolution: Killing the Sprawl
Is your tech stack a sprawling suburb of microservices? Discover why a 40-year-old database is winning the AI infrastructure war.
#1211: Escaping JOIN Hell: The SQL Developer’s Guide to Neo4j
Stop struggling with 15-deep JOINs. Learn how Neo4j turns relationships into first-class citizens for faster, more intuitive data modeling.
#1124: The Database Explosion: Why One Size No Longer Fits All
From vector stores to edge computing, discover why the world now has over 1,000 databases and why Postgres isn't always the answer.
#1123: When One Database Isn't Enough
Can Postgres 18 finally replace the data warehouse? We dive into data gravity, columnar storage, and the physics of scaling in the AI age.
#816: From Scrolls to SQL: The Evolution of Human Order
Explore the history of how we organize the world, from ancient library catalogs to the future of AI-driven vector databases.
#772: Beyond the Build: Can Static Sites Truly Scale?
Is your static site hitting a wall? Discover how modern frameworks handle thousands of pages without crashing your build pipeline.