March 02, 2026

#471 The ORM pattern of 2026?

39 minutes

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: @[email protected] / @mkennedy.codes (bsky)

Brian: @[email protected] / @brianokken.bsky.social

Show: @[email protected] / @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!

...more

View all episodes

By Michael Kennedy and Brian Okken

4.7

212212 ratings

March 02, 2026

#471 The ORM pattern of 2026?

39 minutes

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: @[email protected] / @mkennedy.codes (bsky)

Brian: @[email protected] / @brianokken.bsky.social

Show: @[email protected] / @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!

...more

More shows like Python Bytes

View all

The Changelog: Software Development, Open Source

288 Listeners

The a16z Show

1,107 Listeners

Daily Tech News Show

1,392 Listeners

Software Engineering Daily

629 Listeners

Talk Python To Me

584 Listeners

Super Data Science: ML & AI Podcast with Jon Krohn

308 Listeners

NVIDIA AI Podcast

347 Listeners

Syntax - Tasty Web Development Treats

991 Listeners

Tech Brew Ride Home

970 Listeners

Practical AI

211 Listeners

The Real Python Podcast

140 Listeners

No Priors: Artificial Intelligence | Technology | Startups

145 Listeners

Latent Space: The AI Engineer Podcast

102 Listeners

This Day in AI Podcast

227 Listeners

The AI Daily Brief: Artificial Intelligence News and Analysis

680 Listeners

Share #471 The ORM pattern of 2026?

Sign up to save your podcasts

#471 The ORM pattern of 2026?

#471 The ORM pattern of 2026?

More shows like Python Bytes

The Changelog: Software Development, Open Source

The a16z Show

Daily Tech News Show

Software Engineering Daily

Talk Python To Me

Super Data Science: ML & AI Podcast with Jon Krohn

NVIDIA AI Podcast

Syntax - Tasty Web Development Treats

Tech Brew Ride Home

Practical AI

The Real Python Podcast

No Priors: Artificial Intelligence | Technology | Startups

Latent Space: The AI Engineer Podcast

This Day in AI Podcast

The AI Daily Brief: Artificial Intelligence News and Analysis