No Compromises

Discussing different ways to model data


Listen Later

It's easy to overcomplicate data modeling, especially when enums, relationships, and future requirements are in play. 
 
In the latest episode of the No Compromises podcast, Joel brings Aaron a real-world technical dilemma: how to model a relationship between two models when types are stored as enums, not models. 
 
We discuss the pros and cons of pivot tables versus JSON columns, the importance of context before jumping to solutions, and how developer instincts can sometimes get in the way of clarity.

  • (00:00) - Setting up the technical problem
  • (02:00) - Pivot tables vs JSON columns
  • (05:15) - Filtering and validation considerations
  • (07:15) - Deciding on the best approach
  • (09:50) - Silly bit

  • Would you like us to review your code or application architecture?
    ...more
    View all episodesView all episodes
    Download on the App Store

    No CompromisesBy Joel Clermont and Aaron Saray

    • 4.9
    • 4.9
    • 4.9
    • 4.9
    • 4.9

    4.9

    8 ratings


    More shows like No Compromises

    View all
    The Laravel Podcast by Taylor Otwell, Matt Stauffer

    The Laravel Podcast

    57 Listeners

    Startups For the Rest of Us by Rob Walling

    Startups For the Rest of Us

    710 Listeners

    Darknet Diaries by Jack Rhysider

    Darknet Diaries

    8,088 Listeners

    Notes On Work - by Caleb Porzio by Caleb Porzio

    Notes On Work - by Caleb Porzio

    18 Listeners

    The Stack Overflow Podcast by The Stack Overflow Podcast

    The Stack Overflow Podcast

    62 Listeners

    The Bootstrapped Founder by Arvid Kahl

    The Bootstrapped Founder

    34 Listeners

    All-In with Chamath, Jason, Sacks & Friedberg by All-In Podcast, LLC

    All-In with Chamath, Jason, Sacks & Friedberg

    10,104 Listeners

    Hard Fork by The New York Times

    Hard Fork

    5,539 Listeners

    Mostly Technical by Ian Landsman and Aaron Francis

    Mostly Technical

    26 Listeners