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
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!!
@@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 :)
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
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.
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 video, please create more video with these type of topics
Thank you, I will do my best!
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!
Great content, something new learned that's refreshing!
Glad you enjoyed it!
Really amazing video. Learned something new from this.
Thanks, glad you learned something!
I didn't learn a thing or two. I learned 5. Thanks buddy!
Amazing, glad to hear!
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 🙏
Great point about pre-computed json files. I'll definitely incorporate that into my own app
You won’t regret it!
Precomputed JSON files on a CDN is pretty interesting. I will dive in
🙌
This is such a good video with so many important points covered. Thank you for sharing.
Glad you liked it! 🙏
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
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!
Fantastic. More like this would be great.
Will do!
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!
Nice point about read/writes replica!
Thx!
Great and really smart tips, thank you!
Glad it was helpful!
Excellent Explanation.
Glad you liked it
Great Video!
Thank you!
Nice video, and nice UA Ox!
Haha thanks! 🎸
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 🎉
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
Good informative video
Thanks!
Great tips bro ❤
Appreciate it!
bro please come up with more content like this
I'll do my best 🙏
Great video my man
Thanks! 🙏
great content keep it up 💯
Thank you! Will do!
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
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
Love it
Thx! 🙏
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
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.
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
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!
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!!