Python Bytes

#451 Databases are a Fad

29 snips
Sep 29, 2025
PostgreSQL 18 is here, boasting faster text handling and smoother upgrades! Testing skills are revealed to be more critical than data structures for most jobs. Discover Pyrefly's cool new features for better code navigation. Brian shares joyful pytest and Playwright techniques that are game-changers for debugging. Plus, a dive into the upcoming Python 3.14 release and Django 6 alpha features. Finally, enjoy a funny joke about a database mishap that didn't go quite as planned!
Ask episode
AI Snips
Chapters
Transcript
Episode notes
INSIGHT

PostgreSQL 18 Boosts Performance And Security

  • PostgreSQL 18 adds an async I/O subsystem and smarter query planning to speed scans and vacuums.
  • Upgrades, UUID v7, and native OAuth2 improve performance, ordering, and security for many apps.
ADVICE

Prioritize Learning Practical Testing Skills

  • Learn and practice testing because you'll use it constantly in real-world software.
  • Do not rely solely on DSA interview prep; focus on test design and higher-level tests to be valuable on teams.
INSIGHT

High-Level Tests Reveal System Behavior

  • Unit tests are common but higher-level API and UI tests reveal system behavior and reduce regressions.
  • Strong high-level testing skills make you invaluable even as tooling and AI evolve.
Get the Snipd Podcast app to discover more snips from this episode
Get the app