@@sabatino-dev I'd be curious about some insights on how you gained the first customers for your SaaS, maybe you could do a video about that in the future :)
Amazing tips as always, its the first time i hear about pre-computed json files in cdn, wonder how i can utilize it one day, Thank you and Best of luck!!
Thank u for such a great content as a Laravel developer i learn alot and also in next video can u explain how we can optimize yajra datatables efficiently
Could you make separate videos about each of below topics explain it in details with real world examples. please ? - Separate Ready and Write ( Insert, update & delete ) connection to database. - Batch inserts & updates. - Don't synchronous reports ( but report in queue so other tasks in app won't slow because of slow reports ). Also what do you think of using Laravel Octane with Swoole or FrankenPHP for scaling ?
I have some videos on my backlog for those topics 🙏 I rarely use Octane, but the way I’d use it is to optimise specific routes. For example, I have a /pingback route that is used by client machines to signal their status once every minute. I run this route with Octane because it gets used 600-800 times per minute. Using Octane, we can skip setting up the entire framework that many times, and thus making the route much faster
What are your thoughts on relations & accessors on reports or pagination data? Eloquent with relation + accessors VS Query Builder with joins? Herd many times that laravel is fast and scaleable, but using Eloquent with rleations + accessors, very quickly becomes bottleneck. Very quickly At least when I tried, of course i found mistakes in how I managed it, but it was not intentional and obvious in start and was too late to notice. After a year of data the started collapsing in response time. from second to 10s of seconds
I try to avoid accessors as it's often a source of N+1 queries. Other than that - I do think you can keep Eloquent queries performant, but you need to take special care.
In many systems full-page cache applies to non-logged in users only, because of state as you pointed out. Alternatively, you could fetch state asynchronously using an API.
Currently no plans of doing that unfortunately, but that may change in the future. You can join the discord server where I'll do announcements of this type of stuff discord.gg/CPnUMM7s
Why do you need to use AWS DBMS service when you have AWS Aurora or AWS RDS Multi-AZ? And regarding precomputed files and CDN, your solution involves some client side processing, the app is not full server side from what i understand, involving a JS framework/library or some vanilla JS is required, meaning that Laravel is not part of this improvement.
Initially we hosted our database at Linode (no read-replica), so we had to use DBMS to migrate off of Linode. Regarding the precomputed files -> Laravel is in fact part of the solution, it validates the data, merges open orders on it, invalidates caches, marks orders as stale, sends events, ... - the app is in fact a Vue SPA, but Laravel does a lot of processing behind the scenes.
Currently no plans of doing that unfortunately, but that may change in the future. You can join the discord server where I'll do announcements of this type of stuff discord.gg/CPnUMM7s
Great man, finally i am watching someone talking about advanced optimization in Laravel
Thanks for watching 🙏
Great video! It’s awesome to hear real world problems that are solved compared to just examples of how these things could be used
Glad it was helpful!
I didn't learn a thing or two. I learned 5. Thanks buddy!
Amazing, glad to hear!
Great point about pre-computed json files. I'll definitely incorporate that into my own app
You won’t regret it!
Great content, something new learned that's refreshing!
Glad you enjoyed it!
Precomputed JSON files on a CDN is pretty interesting. I will dive in
🙌
Really amazing video. Learned something new from this.
Thanks, glad you learned something!
Great video, I love the insights about your own app and the learnings!
Keep it up😊
Thank you! Will do!
@@sabatino-dev I'd be curious about some insights on how you gained the first customers for your SaaS, maybe you could do a video about that in the future :)
Good idea, thanks for the suggestion!
This is such a good video with so many important points covered. Thank you for sharing.
Glad you liked it! 🙏
This is amazing! keep up the good work!
This is real use case. This is very cool than others teaching only from their theories
I learn more by doing myself instead of just reading the theory, so I like to translate that into the videos 👏
@@sabatino-dev your content is gold, eventually the whole laravel community will be able to see this 🎉
Amazing tips as always, its the first time i hear about pre-computed json files in cdn, wonder how i can utilize it one day, Thank you and Best of luck!!
Thanks for the kind words!
Great video, please create more video with these type of topics
Thank you, I will do my best!
Thank u for such a great content as a Laravel developer i learn alot and also in next video can u explain how we can optimize yajra datatables efficiently
Good idea! Will note it down, thanks! :-)
Great and really smart tips, thank you!
Glad it was helpful!
Fantastic. More like this would be great.
Will do!
Nice point about read/writes replica!
Thx!
Excellent Explanation.
Glad you liked it
I love you!!!!!!!!!!! You are a GOD among men!
🙏
I really like the idea of Tables.json files, want know more about his how you are doing that.
Might make a separate video about this entire topic 🙏
Nice video, and nice UA Ox!
Haha thanks! 🎸
Could you make separate videos about each of below topics explain it in details with real world examples. please ?
- Separate Ready and Write ( Insert, update & delete ) connection to database.
- Batch inserts & updates.
- Don't synchronous reports ( but report in queue so other tasks in app won't slow because of slow reports ).
Also what do you think of using Laravel Octane with Swoole or FrankenPHP for scaling ?
I have some videos on my backlog for those topics 🙏 I rarely use Octane, but the way I’d use it is to optimise specific routes. For example, I have a /pingback route that is used by client machines to signal their status once every minute. I run this route with Octane because it gets used 600-800 times per minute. Using Octane, we can skip setting up the entire framework that many times, and thus making the route much faster
Great tips bro ❤
Appreciate it!
Great Video!
Thank you!
Great video my man
Thanks! 🙏
Awesome video was just curious what are you using for creating json files up to date
No specific libraries, we just have a TableResource and the output of that resource will be sent to S3 using the AWS SDK
Really good video, thanks!
Thanks!
Great video, thanks for the tips. Which tool are you sing to view the raw queries?
Thanks! It's barryvdh/laravel-debugbar
What about more processing power though octane?
Octane video will come soon, stay tuned 😎
great content keep it up 💯
Thank you! Will do!
Good informative video
Thanks!
with your current setup and load what is the specs of your RDS instance?
Main: db.m6g.2xlarge (Multi-AZ)
Read-replica: db.m6g.large
@@sabatino-dev thank you, keep up the good work on delivering high quality contents 👏🏻
What are your thoughts on relations & accessors on reports or pagination data?
Eloquent with relation + accessors VS Query Builder with joins?
Herd many times that laravel is fast and scaleable, but using Eloquent with rleations + accessors, very quickly becomes bottleneck. Very quickly
At least when I tried, of course i found mistakes in how I managed it, but it was not intentional and obvious in start and was too late to notice. After a year of data the started collapsing in response time. from second to 10s of seconds
I try to avoid accessors as it's often a source of N+1 queries. Other than that - I do think you can keep Eloquent queries performant, but you need to take special care.
which database do you use? any video on setting up a read replica?
We currently use AWS RDS, I might create a video on how to set up a read-replica!
@@sabatino-dev thanks an open sourced DB will be good too!
@@sabatino-devplease make a video about read replica
bro please come up with more content like this
I'll do my best 🙏
Love it
Thx! 🙏
How to manage a full-page cache when the page has also state? (e.g. a logged-in user shown in the header, or other user-specific info)
In many systems full-page cache applies to non-logged in users only, because of state as you pointed out. Alternatively, you could fetch state asynchronously using an API.
i need to learn more from this, do you have special paid consultations?
Currently no plans of doing that unfortunately, but that may change in the future. You can join the discord server where I'll do announcements of this type of stuff discord.gg/CPnUMM7s
Why do you need to use AWS DBMS service when you have AWS Aurora or AWS RDS Multi-AZ?
And regarding precomputed files and CDN, your solution involves some client side processing, the app is not full server side from what i understand, involving a JS framework/library or some vanilla JS is required, meaning that Laravel is not part of this improvement.
Initially we hosted our database at Linode (no read-replica), so we had to use DBMS to migrate off of Linode.
Regarding the precomputed files -> Laravel is in fact part of the solution, it validates the data, merges open orders on it, invalidates caches, marks orders as stale, sends events, ... - the app is in fact a Vue SPA, but Laravel does a lot of processing behind the scenes.
Why aren't you using the built-in Laravel cache system?
I do use it, but sometimes it’s not enough. I’m talking about handling hundreds (if not thousands) of requests per second in a (cost) efficient way.
@@sabatino-dev could you make a comparison between the two?
Good suggestion!
How I wish the entire backend ecosystem is just PHP and Laravel.
You and me both 😅
@@sabatino-devyou have 2 million user bro make a video how to search feature on that like e-commerce app
What other frameworks u know
thanks baby
Appreciated!
Your accent sounds Belgian, your name Italian and your face Indian. Did I get any of that right? 😊
Italian living in Belgium, so 2 out of 3 😂👏
After watching more of the video, and seeing the food ordering webapp, I’m pretty sure I got the Belgian part right 😅
@sabatino-dev can i have consultation, if so please get back to me because i really need your assistance?
Currently no plans of doing that unfortunately, but that may change in the future. You can join the discord server where I'll do announcements of this type of stuff discord.gg/CPnUMM7s
@@sabatino-dev thank you ma man!!
Great man, finally i am watching someone talking about advanced optimization in Laravel
Thanks! 🙏