{"podcast":{"title":"The Bootstrapped Founder","slug":"the-bootstrapped-founder","podcast_index_feed_id":1212107,"rss_url":"https://feeds.transistor.fm/bootstrapped-founder","website_url":"https://thebootstrappedfounder.com/","image_url":"https://img.transistorcdn.com/JW89dtLz0VlpI1LxKyJLAi1wcAl8G0or-KMbYrAnQhw/rs:fill:0:0:1/w:1400/h:1400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/Lzc0MTAvMTY2ODg3/NTEzMC1hcnR3b3Jr/LmpwZw.jpg","author":"Arvid Kahl","episode_count":442,"summary":"Arvid Kahl talks about starting and bootstrapping businesses, how to build an audience, and how to build in public.","last_synced_at":null,"page_url":"https://stenobird.com/podcast/the-bootstrapped-founder"},"episode":{"title":"426: How Your Data Model Shapes Your Product","slug":"426-how-your-data-model-shapes-your-product","published_at":"2025-12-05T11:00:00+00:00","page_url":"https://stenobird.com/podcast/the-bootstrapped-founder/426-how-your-data-model-shapes-your-product","show_page_url":"https://stenobird.com/podcast/the-bootstrapped-founder","url":"https://tbf.fm/episodes/426-how-your-data-model-shapes-your-product","audio_url":"https://2.gum.fm/op3.dev/e/pdcn.co/e/pdst.fm/e/dts.podtrac.com/redirect.mp3/media.transistor.fm/08ba2219/a4f45715.mp3","summary":"Your initial data model is a double-edged sword that can either enable rapid feature development or create permanent technical debt. This episode explores how early architectural decisions regarding database structure and user relationships impact scalability and product flexibility.","meta_description":"Learn how early data modeling decisions impact product scalability, from managing massive MySQL migrations to implementing flexible user authentication.","key_points":["Main idea: A rigid data model acts as a ceiling for your product's potential features","Failure mode: Storing related data in separate tables can create massive migration hurdles as you scale","Practical takeaway: Use blue-green deployments to perform heavy database migrations without downtime","Practical takeaway: Offload large, infrequently accessed text data to object storage like S3 to maintain database performance","Main idea: Building for flexibility means being prepared to execute complex infrastructure changes as requirements evolve"],"chapters":[{"start_ms":60000,"title":"The Cost of Fragmented Data","summary":"Reflecting on Jack Ellis's mistake of separating page views and custom events into different tables."},{"start_ms":260000,"title":"The Illusion of the Perfect Model","summary":"Why early-stage developers often overlook the long-term implications of their initial schema design."},{"start_ms":360000,"title":"Designing for Teams and Auth","summary":"The complexity of introducing multi-user access and team structures into an existing user model."},{"start_ms":660000,"title":"Scaling MySQL and Migration Pain","summary":"The technical challenges of adding indices and altering fields in tables containing millions of rows."},{"start_ms":860000,"title":"Moving Beyond Relational Search","summary":"Why standard SQL text search fails at scale and the transition to specialized search clusters."},{"start_ms":1160000,"title":"Implementing Cold Storage","summary":"Optimizing costs and performance by moving large transcript payloads to object storage."},{"start_ms":1260000,"title":"The Founder's Mindset on Infrastructure","summary":"Embracing the necessity of migrations and infrastructure changes to support product growth."}],"topics":["Data Modeling","Database Scalability","MySQL","SaaS Architecture","Infrastructure Management","Software Engineering","Product Development","Cloud Storage"],"duration_seconds":1364,"processing_state":"processed","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/the-bootstrapped-founder/episodes/426-how-your-data-model-shapes-your-product/transcription-requests","description":"Idempotently request low-priority transcript generation for this episode."},{"name":"read_markdown","method":"GET","url":"https://stenobird.com/podcast/the-bootstrapped-founder/426-how-your-data-model-shapes-your-product.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}