Performance comparison: raw versus ORMs

• Raw+DC: The ORM pattern of 2026?
• pytest-check releases
• Dataclass Wizard
• SQLiteo - “native macOS SQLite browser built for normal people”
• Extras
• Joke

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!