All Models Are Wrong (with James Gayfer)

Dead Code

Content provided by Jared Norman. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Jared Norman or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://podcastplayer.com/legal.

2M ago 26:23

MP3•Episode home

In this episode of Dead Code, Jared interviews James Gayfer about data modeling and the challenges of structuring databases effectively. James, who prefers raw SQL over ORMs, explains how many database models merely mirror table structures, leading to inefficient APIs and excessive data fetching. He discusses the concept of complete versus incomplete data models, emphasizing that completeness depends on an application’s needs at a given time. They explore trade-offs between overly simplistic models that require frequent queries and overly complex ones that attempt to replicate real-world relationships in unnecessary detail. James advocates for designing domain models thoughtfully, using patterns like repositories to maintain consistency while keeping data retrieval manageable. Ultimately, he encourages developers to embrace iteration, rethink their models as needed, and accept that all models are wrong, but some are useful.

Links:

James Gayfer’s Blog

James Gayfer’s Mastodon profile

SQLx library for Rust

All models are wrong, but some are useful

Dead Code Podcast Links:

Mastodon

Jared’s Links:

Mastodon

twitch.tv/jardonamron

Jared’s Newsletter & Website

Episode Transcript

Hosted on Acast. See acast.com/privacy for more information.

40 episodes

#Tech #Jared Norman #Software Development #Programming #Software Engineering #Software #Computer Science