#471 The ORM pattern of 2026?
#471 The ORM pattern of 2026?  
Podcast: Python Bytes
Published On: Mon Mar 02 2026
Description: Topics covered in this episode: Raw+DC: The ORM pattern of 2026? pytest-check releases Dataclass Wizard SQLiteo - “native macOS SQLite browser built for normal people” Extras Joke Watch on YouTube About the show Sponsored by us! Support our work through: Our courses at Talk Python Training The Complete pytest Course Patreon Supporters Connect with the hosts Michael: @mkennedy@fosstodon.org / @mkennedy.codes (bsky) Brian: @brianokken@fosstodon.org / @brianokken.bsky.social Show: @pythonbytes@fosstodon.org / @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 developers They are not the native language of agentic AI Raw queries are trained 100x+ more than standard ORMs Using raw queries at the data access optimizes for AI coding Returning some sort of object mapped to the data optimizes for type safety and devs Brian #2: pytest-check releases 3 merged pull requests 8 closed issues at one point got to 0 PR’s and 1 enhancement request Now back to 2 issues and 1 PR, but activity means it’s still alive and being used. so cool Check out changelog for all mods A 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 explanation But 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 coverage No Inheritance Needed Brian #4: SQLiteo - “native macOS SQLite browser built for normal people” Adam Hill This 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 tools Some notes on my thoughts when evaluating I know mac rules around installing .dmg files not from the apple store are picky. And I like that But I’m ok with the override when something comes from a dev I trust The contributors are all Adam I’m still not sure how I feel about letting agents do commits in repos There’s “AGENTS” folder and markdown files in the project for agents, so Ad Extras Michael: PyTV Python Unplugged This Week IBM Crashes 11% in 4 Hours - $24 Billion Wiped Out After Anthropic's Claude Code Threatens the Entire COBOL Consulting Industry Loving my 40” ultrawide monitor more every day Updatest for updating all the mac things Ice has Thawed out (mac menubar app) Joke: House is read-only!