Topics include:<ul><li>Issues you run into when you do too much work in code instead of in the database</li><li>Why memory usage is just as important as query count</li><li>How being smarter with your database usage can let you avoid hard problems like cache invalidation</li><li>Denormalizing computable data to make it queryable</li><li>Using "where not exists" strategically to improve query performance</li><li>Why the solution to n+1 problems isn't always as simple as eager-loading</li><li>How subqueries work and how you can use them to avoid memory problems when eager-loading</li></ul>Sponsors:<ul><li><a href="https://ohdear.app">Oh Dear!</a>, sign up with the coupon code "FULLSTACKRADIO" to get 50% off your first month</li><li><a href="https://rollbar.com/fullstackradio">Rollbar</a>, sign up at https://rollbar.com/fullstackradio and install Rollbar in your app to receive a $100 gift card for <a href="https://opencollective.com/">Open Collective</a></li></ul>Links:<ul><li><a href="https://refactoringui.com/book">Refactoring UI</a></li><li><a href="https://reinink.ca/articles/dynamic-relationships-in-laravel-using-subqueries">"Dynamic relationships in Laravel using subqueries"</a> on Jonathan's blog</li><li><a href="https://github.com/reinink/laracon2018">Source code</a> for Jonathan's Laracon Online talk</li><li><a href="https://stackoverflow.com/questions/173041/not-in-vs-not-exists">The benefits of NOT EXISTS</a> on StackOverflow</li><li><a href="https://github.com/reinink/advanced-eloquent">Advanced Eloquent</a>, Jonathan's Laravel package</li></ul>

In this episode, Adam talks to Jonathan Reinink about strategies for off-loading resource intensive work from your application code and into your database.

Full Stack Radio

104: Jonathan Reinink - Pushing More Work to the Database