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.

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

[@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

[@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

[@nightpegasus26]

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

[@aschmelyun]

Thanks! I'm glad you liked it!

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

[@aibarra11]

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

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

[@javieru5871]

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

[@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!

[@josegerardosanchezalvarado4703]

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

[@sebastianromerolaguna7408]

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

[@jecoy9413]

what text editor are you using ?

[@bf-xi3om]

Found your channel recently. Good Stuff, keep going.

[@fractalzombie]

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

[@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?

[@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?

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

[@tannercampbell]

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

[@ehSamurai3483]

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

[@pamithbosilu6055]

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

[@pamithbosilu6055]

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

[@sretksor8689]

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

[@lawrencediokno4883]

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

[@mikevazovsky9211]

Good!

[@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

[@randomguy5922]

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

[@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

[@androidbornofficial5148]

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

[@rizkihutama5633]

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

[@joepalala4757]

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

[@arty4]

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

[@gergelygrusz713]

This is brilliant, thank you!

[@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!

[@hariharan-wt6qk]

Thanks a lot❤️

[@epslks]

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

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

[@sayedahmadnaweed1]

You are amazing. Thank you

[@loremipsum5642]

Hi, can you provide a github repo for this?

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

[@indeveloperid6061]

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

[@Chitte011]

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

[@sebastianromerolaguna7408]

Thanks, it help me.

[@DRMOHAMEDKHDR]

Thanks alot

[@MohanSingh-pl1mi]

I really like the way you are using to elaborate

[@pankajbokdia]

Super helpful!

[@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!

[@paulmimicry9147]

How about the amount of query executed?

[@JohnnyBigodes]

And another great and useful examples. Thank you

[@simbarashemaunga5575]

This was an amazing tutorial!

[@asim-gandu-phenchod]

Diamond content

[@jailsoncarneiro4936]

Great Job! Thanks a lot!

[@sudheertripathi3882]

tip3 is fire

[@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!

[@naungyehtet1231]

Subscribed

[@truongpm2144]

amazing !!!!

[@brokoli5797]

Great tips! saved my time so much.

[@197syahnur]

tip 2 is super brand new to me! Thankss

[@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

[@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()"

[@grayaahammed917]

What IDE is used in this video please ?

[@gobanq]

It’s phpstorm

[@ethanj1533]

What ide is that?

[@namachivaaya]

Nice tips 👍👍👍

[@silvesterwali6565]

i love this

[@mastago3226]

thank you Andrew

[@johnmarkenriquez8808]

Super helpful..

[@carlosfranciscobenegasbini78]

Amazinng!

[@davidmucioca6423]

Very helpful

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

[@emadaldeenmukhtar]

perfect bro, keep it up

[@Arman-cn2tf]

Great

[@mithicherbaro9394]

Great tips 👍

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