Go offline with the Player FM app!
Discussing different ways to model data
Manage episode 520574537 series 2974897
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?
140 episodes
Manage episode 520574537 series 2974897
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?
140 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.