In this series, you'll 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. This course is a culmination of everything I've learned along my journey, distilled into a single course. We're going to dig deep into advanced real world problems.
Overview
Syllabus
- Techniques
- Measuring Your Database Performance
- Minimize Memory Usage
- Getting One Record From a Has-Many Relationship
- Dynamic Relationships Using Subqueries
- Calculate Totals Using Conditional Aggregates
- Optimize Circular Relationships
- Search Feature
- Multi-Column Searching
- Getting LIKE to use an Index
- Faster Options Than whereHas
- When it Makes Sense to Run Additional Queries
- Use Unions to Run Queries Independently
- Fuzzier Searching With Regular Expressions
- Performance
- Run Authorization Policies in the Database
- Faster Ordering With Compound Indexes
- Options for Ordering by a HasOne Relationship
- Options for Ordering by a BelongsTo Relationship
- Options for Ordering by a HasMany Relationship
- Options for Ordering by a BelongsToMany Relationship
- Ordering With NULLs Always Last
- Ordering By Custom Algorithms
- Filtering and Sorting Anniversary Dates
- Make N+1 Issues Impossible
- Ordering Data For Humans Using Natural Sort
- Full Text Searching With Rankings
- Get the Distance Between Geographic Points
- Filter by Geographic Distance
- Order by Geographic Distance
- Filter by Geospatial Area
Taught by
Jonathan Reinink