104: Jonathan Reinink - Pushing More Work to the Database

Topics include:Issues you run into when you do too much work in code instead of in the databaseWhy memory usage is just as important as query countHow being smarter with your database usage can let you avoid hard problems like cache invalidationDenormalizing computable data to make it queryableUsing "where not exists" strategically to improve query performanceWhy the solution to n+1 problems isn't always as simple as eager-loadingHow subqueries work and how you can use them to avoid memory problems when eager-loadingSponsors:Oh Dear!, sign up with the coupon code "FULLSTACKRADIO" to get 50% off your first monthRollbar, sign up at https://rollbar.com/fullstackradio and install Rollbar in your app to receive a $100 gift card for Open CollectiveLinks:Refactoring UI"Dynamic relationships in Laravel using subqueries" on Jonathan's blogSource code for Jonathan's Laracon Online talkThe benefits of NOT EXISTS on StackOverflowAdvanced Eloquent, Jonathan's Laravel package