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 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

Episode source