Learn to test your Laravel apps with Test Driven Laravel

Improve your database performance! No images? Click here Eloquent Performance Patterns: Improve your database performance! If you'd like to learn how to drastically improve the performance of your Laravel applications by pushing more work to the database, all while still using the Eloquent ORM. Jonathan Reinink learned that by leveraging advanced database techniques, like subqueries, conditional aggregates, and aggressive use of scopes, pages that took 30+ seconds to load were now loading within 500ms!!  If you'd like to learn more about leveraging your database to improve performance then this course is for you. You'll learn:  The three key metrics to better database performance The incredible power of sub queries When to use joins vs sub queries Using sub queries to select related data Using sub queries to build dynamic relationships Using sub queries to order by related data Calculating totals using conditional aggregates Running authorization policies in the database Building complex search filters Extending the query builder using macros Demystifying database indexes Introducing complex queries without sacrificing Eloquent's API Leveraging vendor-specific (MySQL, Postgres, etc.) features Caching and database denormalization How to safely write raw database queries Configuring Laravel to make N+1 issues impossible Extending Eloquent to support ordering with NULLS LAST and NULLS FIRST Getting the distance between two geographic points Filtering by geographic distance Ordering by geographic distance Querying records within a physical area using geospatial shapes Get the course       Share    Tweet    Share    Forward  Laravel News  PO Box 196 Cramerton NC, 28032 Send us a postcard! You are receiving this because you joined the Laravel News weekly digest. If you know someone who would enjoy this newsletter please consider sharing it.  Preferences  |  Unsubscribe