Laravel Pro Tips
🔥 #Laravel Tip: Eloquent's 'whereExists' method is useful, but it relies on sub queries. A more efficient way to run the same query is an advanced inner join.
You've probably joined an array into a comma separated string before. But what about when you want the last one to say "and"? With Laravel collections it's a breeze 🍃
A nice SQL trick - you can update a table from another table using joins 👀
Just added a `deleted_at` column to a table and want it populated by one of it's relations, just do an update statement and join them.
One simple, yet powerful query 🤯
Jan 17th, 2022
Efficient Pagination Using Deferred Joins
A slight modification to traditional offset/limit pagination that can drastically boost performance.