Episode 104
104: Jonathan Reinink - Pushing More Work to the Database
In this episode, Adam talks to Jonathan Reinink about strategies for off-loading resource intensive work from your application code and into your database.
December 19, 20181h 1m
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Topics include:
- Issues you run into when you do too much work in code instead of in the database
- Why memory usage is just as important as query count
- How being smarter with your database usage can let you avoid hard problems like cache invalidation
- Denormalizing computable data to make it queryable
- Using "where not exists" strategically to improve query performance
- Why the solution to n+1 problems isn't always as simple as eager-loading
- How subqueries work and how you can use them to avoid memory problems when eager-loading
Sponsors:
- Oh Dear!, sign up with the coupon code "FULLSTACKRADIO" to get 50% off your first month
- Rollbar, sign up at https://rollbar.com/fullstackradio and install Rollbar in your app to receive a $100 gift card for Open Collective
Links:
- Refactoring UI
- "Dynamic relationships in Laravel using subqueries" on Jonathan's blog
- Source code for Jonathan's Laracon Online talk
- The benefits of NOT EXISTS on StackOverflow
- Advanced Eloquent, Jonathan's Laravel package
Topics
technologysoftwarewebdevelopmentproductstartup