

374: Indie Hacking Databases at Scale
36 snips Feb 7, 2025
Databases can be daunting, especially for indie founders facing budget constraints and customer demands. The conversation dives into mastering database management, emphasizing the importance of scalability and efficient indexing. Learn about the challenges from transitioning to larger systems while maintaining performance. Discover valuable insights from personal experiences in running sizable SaaS offerings, shedding light on the intricacies of handling terabytes of data.
AI Snips
Chapters
Books
Transcript
Episode notes
Slow Queries
- Arvid Kahl's simple database queries in PodScan started taking hours to complete.
- This highlighted the importance of database indices for efficient data retrieval.
Index Timing
- Add database indices during table creation to avoid future performance issues.
- Adding indices later to large tables can cause significant downtime.
Downtime
- Adding a new index to PodScan's database resulted in potential downtime.
- This led Arvid to explore alternative solutions like blue-green deployments.