Laravel Pro Tips
#joins #eloquent
🔥 #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.
Matt Kingshott
#joins #collections
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 🍃
Daniel Eckermann
#joins #sql
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 🤯
Oliver Nybroe
Jan 17th, 2022
#pagination #joins
Efficient Pagination Using Deferred Joins
A slight modification to traditional offset/limit pagination that can drastically boost performance.