5 tips for supercharged Laravel Eloquent queries

[@CyanidePierce90]

To add to tip 1. If you want to avoid "if" blocks, you can use the eloquent "when" method. return Property::query() ->when($request->get('rent'), function ($query) use ($request) { return $query->where('rent', 'when($request->get('rent'), fn($query) => $query->where('rent', '

[@aschmelyun]

Just learned about the when() method from someone on dev.to! I'll definitely be keeping this in mind, as that's a way cleaner syntax.

[@featurive]

Also I would recommend using $request->has() instead of get for if statements.

[@CyanidePierce90]

@@aschmelyun yeh it's much nicer, but we don't know these things until we know them :)

KZbin should add code formatting in the comment system... By the way I've learnt about $builder->when() from Reinink (Inertiajs).

[@randomguy5922]

nice.

[@nightpegasus26]

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

[@aschmelyun]

Thanks! I'm glad you liked it!

[@ameerhamza4373]

I haven't watched complete video but still i believe that this is going to be one of the best video on eloquent... Much love for you keep up the good work

[@thebirdhasbeencharged]

Have you seen Jonathan Reinink's course. Gold! Not to take away from this video however. Wish these existed a couple years ago.

[@laybyyourside]

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

[@sumitsharma-us2sl]

Remember: sortBy won't work with pagination if you are looking for appended column sorted

[@AnastasVartanyan]

The Tip four that adds requests count attribute will cause extra db call for each technician since to compute the model attributes aggregate query will be executed. To deal with this problem you can use Laravel Eloquent Query Builder `withCount` method like->withCount('requests'). The method will add requests_count attribute for each model with single query

[@Shez-dc3fn]

alternatively he could just do $this->requests->count() in the accessor since your method means laravel might make two calls one for withCount and one for with?

[@AnastasVartanyan]

@@Shez-dc3fn surely you can do this way too, but in that case you need to make sure that your relation is always loaded, if not the accessor will be querying the db. Also this way you force the count to be calculated in the collection, this means that php will count your relations and that can take some resources and memory if the count is huge, so I would prefer using withCount that will count the relations using SQL SUM aggregation, it will take a lot less resources with big data.

[@tannercampbell]

Great video! I am constantly dealing with dates and expirations within my App, tip 5 is gonna be super helpful!

[@MohanSingh-pl1mi]

I really like the way you are using to elaborate

[@AbrahamChavez]

Great tips Andrew, I'm wondering what keyboard are you using, there is an audible click that I find very satisfying.

[@sumitsharma-us2sl]

Not sure but it 'TVS Gold' sounds same, please check with your hardware and OS compatibility as some models are still mechanical.

[@abiyouth_]

Agreed

[@epslks]

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

[@gergelygrusz713]

This is brilliant, thank you!

[@randomguy5922]

Very useful things..........i almost know all of them but its surely some parts where new. Thanks

[@bf-xi3om]

Found your channel recently. Good Stuff, keep going.

[@cultureofnepal2024]

Awesome tips. Please post more video on eloquent tips Andrew.

[@aschmelyun]

I'll have to compile some more and make a part 2!

[@cultureofnepal2024]

@@aschmelyun please share code too.

[@brokoli5797]

Great tips! saved my time so much.

[@jecoy9413]

what text editor are you using ?

[@simbarashemaunga5575]

This was an amazing tutorial!

[@aibarra11]

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

[@JohnnyBigodes]

And another great and useful examples. Thank you

[@stefanbogdanovic590]

Awesome video, I have suggestion you could make a new custom Request for example TenantSearchRequest and you should make all query parameters nullable and add string boolean validation etc, so you could get only those that are inside the request so you don't have to be scared if someone sends you a parameter you don't expect in you API for an example, and you get those parameters with $request->validated() and apply same logic. And one more since you are using PHP storm use laravel ide helper to generate models annotations for intellisense, and you can access requests_count dynamic fields. Cheers mate!

[@sayedahmadnaweed1]

You are amazing. Thank you

[@DANJ93Mort]

Nice job, thanks

[@197syahnur]

tip 2 is super brand new to me! Thankss

[@jailsoncarneiro4936]

Great Job! Thanks a lot!

[@guilhermemoraes4055]

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

[@FranckMercado]

It's a local custom domain he setup in his computer. In Linux you can do it by adding your domain to /etc/hosts file.

[@vaibhavdeokar7642]

nice video Which extention you use for suggetion

[@CyanidePierce90]

I believe that is PHPStorm, autocomplete is built into it.

[@aschmelyun]

Correct, my IDE is PHPStorm. If you're asking about the suggestions in the terminal window, I'm using a ZSH plugin called zsh-autosuggestions.

[@hariharan-wt6qk]

Thanks a lot❤️

[@yacobee]

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?

[@lawrencediokno4883]

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

[@namachivaaya]

Nice tips 👍👍👍

[@sebastianromerolaguna7408]

Thanks, it help me.

[@pankajbokdia]

Super helpful!

[@iShah300]

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 ...

[@javieru5871]

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

[@delita0057]

are you doing nuxt js tutorials?

[@aschmelyun]

It's on my list, and I'm hoping to have a video showing how to get started with Nuxt pretty soon!

[@mikevazovsky9211]

Good!

[@Chitte011]

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

[@rizkihutama5633]

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

[@sretksor8689]

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

[@mithicherbaro9394]

Great tips 👍

[@sebastianromerolaguna7408]

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

[@mastago3226]

thank you Andrew

[@ehSamurai3483]

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

[@aschmelyun]

If you'd like to see the full source code behind this video, I've created a repo for it here: github.com/aschmelyun/video-5-laravel-eloquent-tips Also, if you'd like to directly support these videos and open-source projects, consider sponsoring me on GitHub: github.com/sponsors/aschmelyun

[@indeveloperid6061]

Why we have to write like "uri" or "action" at route code ?

[@androidbornofficial5148]

Amazing video. Please make video Vue js pagination with later with filter queue string.

[@DRMOHAMEDKHDR]

Thanks alot

[@davidmucioca6423]

Very helpful

[@arty4]

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

[@emadaldeenmukhtar]

perfect bro, keep it up

[@sudheertripathi3882]

tip3 is fire

[@paulmimicry9147]

How about the amount of query executed?

[@hossamsalim4426]

Could you help please - I have inventory system with 2 models (invoice) with relationship items morphMany Item model I need to get item record with MAX date of purchase

[@johnmarkenriquez8808]

Super helpful..

[@sheenismhaellim2215]

How does the object $poperties know what table to query just by initializing it with Property::query()?

[@wsqplm]

Grabbed from laravel docs: By convention, the "snake case", plural name of the class will be used as the table name unless another name is explicitly specified. So, in this case, Eloquent will assume the Property model stores records in the properties table.

[@grayaahammed917]

What IDE is used in this video please ?

[@gobanq]

It’s phpstorm

[@truongpm2144]

amazing !!!!

[@edwinencomienda]

what’s your keyboard 😅?

[@aschmelyun]

It's a DIY kit I bought and assembled. A GK64 PCB with Kailh Jade Box switches and thick PBT keycaps!

[@Akimb321]

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?

[@AdiSK]

Hi, thanks for the tips. I have one doubt, why not use built in withCount method to get the count on tip 4 How is your method better than the built in method. Great videos by the way🙂

[@tannercampbell]

I think creating a model attribute is better in most scenarios to do this, it’s a bit more reusable if your response is returning more then the count. But you make good point that method works well too!

[@TheMessixaviniesta]

The built in method is way better because with tip 4 you have to ALWAYS eager load the relationship or you will end up with a bunch of queries.

[@TheMessixaviniesta]

For this particular case.

[@TheMessixaviniesta]

Actually it would still make one query for each model even with eager loading because he's using the method "$this->requests()->count()" it would only be acceptable if replaced with "$this->requests->count()"

[@naungyehtet1231]

Subscribed

[@loremipsum5642]

Hi, can you provide a github repo for this?

[@ethanj1533]

What ide is that?

[@etokafrancis5700]

Tip 1: You could also use Laravel pipelines. It abstracts the 'ifs' into classes. If you need to add more filters, you just create a new class without modifying your controller classes app(Pipeline::class) ->send($this->model->query()) ->through( Client::class, CallStatus::class , Sort::class )->thenReturn()->get(); An example: It filters this model by client_id, call_status and then sorts them. The filters are run only when they are present in the request

[@silvesterwali6565]

i love this

[@carlosfranciscobenegasbini78]

Amazinng!

[@josegerardosanchezalvarado4703]

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

[@Arman-cn2tf]

Great

[@pamithbosilu6055]

Laravel Tips and Tricks - kzbin.info/www/bejne/oafPeIqnp8aSqMU

[@fractalzombie]

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

[@asim-gandu-phenchod]

Diamond content

[@davidspooner4684]

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

[@aschmelyun]

Hey David, I'm really sorry about that. I'll see if I can tone them down across my channel. Thanks for letting me know!

[@davidspooner4684]

@@aschmelyun Awesome. Thanks for the reply! Otherwise, I really enjoyed your content. Keep it up!

[@joepalala4757]

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

[@robertoflores2078]

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.

[@pamithbosilu6055]

Laravel Tips and Tricks - kzbin.info/www/bejne/oafPeIqnp8aSqMU