5 tips for supercharged Laravel Eloquent queries

amazing !!!!

Another tip, You can now use ->latest() in your queries which will getlatest by created date (afaik)

This is brilliant, thank you!

This was an amazing tutorial!

what is the name of IDE that you using in video?

I've been using Mehradsadeghi\FilterQueryString for years. Forget about if's and when's. Let the library do all that work for you. I can't find a cleaner way to do it.

Thank you Andrew! Just what I was looking for, but couldn't find anywhere else!

Subscribed

how are you formatting your return data to look like that?

Super helpful!

I think for tip 4, we can also use withCount from Lavaravel 5.2.32 or higher.

You are amazing. Thank you

tip3 is fire

esto me salvo la vida User::whereHas('model', function ($query) {
$query->where('propiedad', '!=', 'value');
})->with(['model', 'model'])->get();

Diamond content

Говнокодик конечно… есть ощущение, что только программисты из СНГ заботятся о качестве кода.

Thank you, how queries from relations e.g, products belong to a category and products also belongs to a type, how to get query of categories that their products have a specific type?

Great Job! Thanks a lot!

For tip 1 u can use ->when($expr, $callback) function

Be careful when using whereHas on large databases as it performs a full table scan. I would use join or whereIn instead.

You are awesome man, great respect for you! (y)

Have you think in do an tutorial explaining queries for statistics. I haven seen videos about!.
Have a good day

Thanks, it help me.

I really like the way you are using to elaborate

Hi andrew
Great tips however i have a question
Hoe about including join if conditiions is true
Like if a request comes so i want to join a new table into existing eloquent query ...

are you doing nuxt js tutorials?

In the first tip what is ::query() method?

Way too many commercials interrupting this tutorial. Hard to follow with so many interruptions.

for the first optimization, there is also ->when for eloquent queries. No need to write out IF statements

i love this

Thanks a lot❤️

what’s your keyboard 😅?

Amazinng!

Great and perfect. Thank you

What's ".test" on your URL project? Is this somehow online?

Good!

Thanks alot

Hi, can you provide a github repo for this?

do you have a video that store json text to database, i'm still strugling with that?

I believe there is no information about ::query method in Laravel docs (your first tip). It's an awesome tip, but I can't believe there's no info about this. Or I missed it?

Great tips! saved my time so much.

I'd looking for tip-two to make a streamlined code for a long time , thanks a lot.
Extraordinary !

Tip number 4 is what I’ve been seeking for a long time. Thanks a lot

very helpfull sir

What ide is that?

what text editor are you using ?