104: Jonathan Reinink - Pushing More Work to the Database
Full Stack Radio
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
Next Episodes
103: Steve Schoger - Design Q&A + Refactoring UI Details @ Full Stack Radio
π 2018-12-05 15:38 / β 01:05:12
102: Paul Jarvis - Staying Small @ Full Stack Radio
π 2018-11-21 20:47 / β 01:06:03
101: Ben Orenstein - How to Build an App in a Week @ Full Stack Radio
π 2018-11-07 06:30 / β 00:55:25
100: SΓ©bastien Chopin - Building Universal Vue.js Apps with Nuxt.js @ Full Stack Radio
π 2018-10-24 06:30 / β 00:48:48
99: Tim Neutkens - Building React Apps with Next.js @ Full Stack Radio
π 2018-10-10 18:32 / β 00:52:02