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:

More from Full Stack Radio