#471 The ORM pattern of 2026?

Topics covered in this episode: Raw+DC: The ORM pattern of 2026?pytest-check releasesDataclass WizardSQLiteo - “native macOS SQLite browser built for normal people”ExtrasJokeWatch on YouTube About the show Sponsored by us! Support our work through: Our courses at Talk Python TrainingThe Complete pytest CoursePatreon Supporters Connect with the hostsMichael: @[e-mail] / @mkennedy.codes (bsky)Brian: @[e-mail] / @brianokken.bsky.socialShow: @[e-mail] / @pythonbytes.fm (bsky) Join us on YouTube at pythonbytes.fm/live to be part of the audience. Usually Monday at 11am PT. Older video versions available there too. Finally, if you want an artisanal, hand-crafted digest of every week of the show notes in email form? Add your name and email to our friends of the show list, we'll never share it. Michael #1: Raw+DC: The ORM pattern of 2026? ORMs/ODMs provide great support and abstractions for developersThey are not the native language of agentic AIRaw queries are trained 100x+ more than standard ORMsUsing raw queries at the data access optimizes for AI codingReturning some sort of object mapped to the data optimizes for type safety and devs Brian #2: pytest-check releases 3 merged pull requests8 closed issuesat one point got to 0 PR’s and 1 enhancement requestNow back to 2 issues and 1 PR, but activity means it’s still alive and being used. so coolCheck out changelog for all modsA lot of changes around supporting mypy I’ve decided to NOT have the examples be fully --strict as I find it reduces readability See tox.ini for explanationBut src is --strict clean now, so user tests can be --strict clean. Michael #3: Dataclass Wizard Simple, elegant wizarding tools for Python’s dataclasses.Features 🚀 Fast — code-generated loaders and dumpers🪶 Lightweight — pure Python, minimal dependencies🧠 Typed — powered by Python type hints🧙 Flexible — JSON, YAML, TOML, and environment variables🧪 Reliable — battle-tested with extensive test coverageNo Inheritance Needed Brian #4: SQLiteo - “native macOS SQLite browser built for normal people” Adam HillThis is a fun tool, built by someone I trust.That trust part is something I’m thinking about a lot in these days of dev+agent built toolsSome notes on my thoughts when evaluating I know mac rules around installing .dmg files not from the apple store are picky. And I like thatBut I’m ok with the override when something comes from a dev I trustThe contributors are all Adam I’m still not sure how I feel about letting agents do commits in reposThere’s “AGENTS” folder and markdown files in the project for agents, so Ad Extras Michael: PyTV Python Unplugged This WeekIBM Crashes 11% in 4 Hours - $24 Billion Wiped Out After Anthropic's Claude Code Threatens the Entire COBOL Consulting IndustryLoving my 40” ultrawide monitor more every dayUpdatest for updating all the mac thingsIce has Thawed out (mac menubar app) Joke: House is read-only!