
 Python Bytes
 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! 
 AI Snips 
 Chapters 
 Transcript 
 Episode notes 
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.
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.
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.
