Learnings from our multi-tenant Laravel application

[@joewlfrd]

This is the best explanation for Laravel Multi-tenant I’ve come across so far. Please consider making a simple tutorial covering this topic in depth. New subscriber and thanks again

[@sabatino-dev]

Thanks for the kind words! Great suggestion! 🙏

[@gianlucadistefano6251]

please more video’s like this.. this really helped me a lot. Gained a lot of insight !

[@sabatino-dev]

Glad it was helpful!

[@johalternate]

It's been long since I found a video so fresh and interesting. Thanks for sharing your experiences. Im definitely looking forward to the video about managing tenant's custom domains.

[@sabatino-dev]

Thanks for your kind words!

[@FelixOrwari]

Your lessons are well-explained and are deeply insightful! I also have a multi-tenant application that I have been developing since 2018, and your video couldn't have come at a better time. I especially love how you use middleware to resolve tenants. This is something I will surely borrow. Thank you, Sabatino!

[@sabatino-dev]

Glad it was helpful!

[@jitxhere]

I am building a multi tenant app too. These were very helpful. Thank you very much

[@sabatino-dev]

Glad it was helpful!

[@constantine9074]

this channel looks very promising !!! good luck and keep it coming

[@sabatino-dev]

Thank you! Will do!

[@florianlutze9068]

Got this video recommended by KZbin - loved it and watched all of your other videos + subscribed. I just wanted to tell you that your content is really good! Keep it up, I love the Laravel related topics on your product. I am also building a SaaS with Laravel at the moment, so I love to get some insights from other devs. Looking forward to your next videos

[@sabatino-dev]

Thanks for the kind words! 🙏

[@WebWordsWave]

I really liked your teaching method.. thanks..

[@sabatino-dev]

Thank you!

[@vasiovasio]

Super useful Real Life Insight! Thank you, Sabatino!

[@sabatino-dev]

Glad it was helpful!

[@Claudio_Pereira]

@joewlfrd I agree with you 100%. Sabatino, you brought us a fantastically simple and clear approach! I can't wait for more videos like this. Congratulations and success! 😃🚀

[@sabatino-dev]

Thanks for the kind words!

[@AbedAbugozah]

What this bro? it's very helpful really you are talking about challenges that absolutely often face me you are amazing, keep going

[@sabatino-dev]

Thank you so much 😀

[@AbdulHaseeb-ot9zg]

bro i just loved the way you explained these concepts waiting eagerly for more such content new subscriber

[@sabatino-dev]

Thanks for the sub!

[@jacksondestima]

Great content! Please upload part 2

[@sabatino-dev]

Thanks! Will do!

[@gamekonet]

Amazing video as always, and showing real world issues to take account of as a developer or business owner. Best Of Luck!!!

[@sabatino-dev]

Thank you!

[@gamekonet]

@@sabatino-dev you are always welcome! I have a question, I am thinking of making my first commercial project, what are the main topics i should read about and be aware of ? I have been a backend developer for 3 years and already aware of all points of performance as a backend developer, and my brother will handle frontend-side, he also have 3 years experience.

[@davaigo2170]

Nice video and audio quality. 👍

[@sabatino-dev]

Thanks!

[@binaryfire]

Another great video! Love the level of technical detail.

[@sabatino-dev]

Glad you enjoyed it! 🙏

[@douglasmaia5332]

Great video! Thank you for examples!

[@sabatino-dev]

Glad it was helpful!

[@isabelphillips451]

This is wonderful, i learnt something new today and I'd like to see your Ceryx implementation for reverse proxy. Subscribed!

[@sabatino-dev]

Thanks!

[@dorepavlic6025]

Awesome videos! Keep up the good work :)

[@sabatino-dev]

Thanks, will do!

[@JarkkoHautakorpi]

I just did a multitenant Laravel app, except each tenant has a separate database, which has some 3rd party software db. Tenant is set in the url and middleware selects the correct database connections. Multiple databases, some common databases and some selected by the tenant in middleware. Models extend common/tenant, and so the queries go to the db that middleware activated.

[@sabatino-dev]

Very nice! How many tenants do you have? How do you deal with migrations?

[@riadhossain5701]

Queries to know!

[@JarkkoHautakorpi]

@@sabatino-dev There are no migrations on a 3rd party app db. Only 4 tenants 🙂SOAP classes and db models are auto generated , from ~100 tables.

[@JarkkoHautakorpi]

@@sabatino-dev Btw, for complex queries like reports and such, it is better to use SQL Views and not Eloquent, except read-only eloquent model for the view. Views can be put in another DB and for those you can use migratios also (when you can't edit 3rd party db)

[@programmertelo]

Thanks for the explanation

[@sabatino-dev]

You're welcome!

[@jacobtims569]

Really helpful video! I've also created a multi-tenant application and ran into many of these problems. One of the problems we still have issues with is tenant-specific email configuration. Can you cover this topic in your next video?

[@sabatino-dev]

Great tip! It’s something we do as well, some customers want us to use their SMTP server, while others only want to customise the ‘from’ address. IIRC: we do this by having a ‘BaseMail’ class that takes in our tenant, and overrides the default (fallback) mail configuration. Every mail we create inherits from this BaseMail class.

[@Kryoxys]

With Laravel 11, you can use the new Context class to pass the tenant into the jobs without having to manually pass it to each job/event.

[@sabatino-dev]

Yes, that’s a life saver indeed!

[@kobbyadjei263]

Great video...looking for to a tutorial on how to achieve similar thing and hopefully that would be soon

[@sabatino-dev]

Thanks!

[@philately]

Really nice, useful videos. Thanks!

[@sabatino-dev]

Glad you like them!

[@raqibnur5086]

Easy to understand 😊

[@sabatino-dev]

Glad to hear that!

[@getupkid84]

Yeah great information. I've been wrestling with numerous different approaches for a multi-tenancy Laravel app over the last few weeks. Do I need multi-database? Do I need single-database? Should I use a package like Tenancy for Laravel or Spatie Multi Tenancy? After watching this video, I think it's clear that it shouldn't be too much of a headache just to roll my own. Thanks for sharing!

[@sabatino-dev]

Glad it was helpful!

[@eduh12]

Amazing video, I would like to hear more information about the Ceryx proxy and how it's used in production

[@sabatino-dev]

Next video will cover this!

[@kennedymwenda3357]

You can do a more detailed video on managing SSL on subdomains if you don't mind. On my SAAS app I had used wildcard subdomains. Also how to setup automatic DNS configuration in a case where a tenant adds a full domain.

[@sabatino-dev]

Next video will cover this!

[@kennedymwenda3357]

@@sabatino-dev Ok thanks

[@shofada]

Hi Sabatino. Thanks for the insight. If you were to do this again today, how would you approach it? Would you use a third-party package or would you build it all yourself?

[@sabatino-dev]

That's a very good question. I think I'm leaning towards steering away from third party packages, because usually they will cover about 90% of your intended use, and will give you a very hard time closing the gap of the last 10%.

[@brightyouthacademy]

Thank you so much for this

[@sabatino-dev]

Thanks for watching!

[@codewithfongoh]

Thank you very much, very insightful

[@sabatino-dev]

Glad it was helpful!

[@taslimsuman]

I'm also doing the same way for my multi tenant rental app

[@sabatino-dev]

🙌

[@digvijayad]

Great video! I am in the process of migrating an existing application into a multi-tenant site and your point 1 what I was debating on. Thank you for the insight. Any particular reason for playwright over dusk? Also feature flags are great!

[@sabatino-dev]

Glad it was helpful! Playwright has an easy integration on AWS Lambda, that’s the only reason basically.

[@cb73]

I’ve done single database tenants before and yeah, it does simply things, but I was constantly scared to death of forgetting about the tenant ID relationship.

[@sabatino-dev]

I know that feeling 🙈 in our app we kinda ‘hinge’ off of a root object, so it’s pretty much impossible to forget it eg. t()->orders()->count() - and t() resolves to the resolved tenant - works great.

[@thecaribcoder]

Can you give some insight on the "getHost" method that you use in your middleware?

[@sabatino-dev]

I created the following gist: gist.github.com/SabatinoMasala/95f839682a673deb2879e1676125a1e1 It's a pretty basic function that helps me filter out specific things from the URL (eg. for local development, or for visiting my application servers directly). It returns a string, eg. demo.example.com, which I can then use to do my queries.

[@ben53933]

Noob here. May I ask to make a video talking about the difference between using Laravel and Code Igniter ? And, when should I use which.

[@sabatino-dev]

Not a big Codeigniter guy I’m afraid 😅 I’ve been doing Laravel for 10+ years, and did CakePHP/Slim before that

[@heyyedwin]

how do you keep your queries fast for the mechant reports?

[@sabatino-dev]

I do a deepdive in this video: kzbin.info/www/bejne/aXSmqKuCiJ2WeJo

[@svndays]

Great video mate, we use a similar approach at a smaller company, it's working well but I am still in the process of converting legacy code, there's a lot of technical debt. Do you use laravel feature tests to make sure you don't accidentally leak other tenants data? Also one thing I came across is we often have big customers who have specific needs and we need to bend the rules of the system for them. Laravel gives us the developer speed necessary to make it happen but it requires careful planning. Using the subdomain to identify tenants has also been an issue for me because we also support logging in from the root domain, so it has to work both ways :)

[@sabatino-dev]

Thanks! We do try to write tests for our most-used features, but we mostly rely on E2E tests using Playwright. We develop every feature behind a 'feature flag', so we don't need to bend the rules for specific customers. Instead, we can just enable a feature flag on their account.

[@khawarali3720]

please tell us how you are handling jobs for tenants?

[@sabatino-dev]

Every job receives a ‘tenant’ in the constructor, but in Laravel 11 you can use ‘context’

[@meerachaturvedi9050]

I am going to have a multitenant with multi domain and multidatabase but the problem is whethere i should go with readymade theme available on codecayon or go with in house development. I am targeting nearly 20k tenants in a year So afraid of collapse of code available on cadecayon .

[@sabatino-dev]

I bought my fair share of Codecanyon projects - and always regretted it. I wouldn't touch anything on Codecanyon as the code quality is usually garbage.

[@bulent2435]

Thanks.

[@sabatino-dev]

You're welcome!

[@vijaykoogu3822]

Please upload daily videos...

[@sabatino-dev]

Will do my best! 👀

[@shadyarbzharothman8689]

Thanks for the video, I have a multi tenant multi database approach and now I want to host it but coz I'm new I don't know where to host, My company want to host it in digital ocean but I need to work with CLI, do you have any suggestion?

[@sabatino-dev]

We host our database on AWS using RDS. Our application servers are on Linode, but I wouldn’t recommend that. DigitalOcean is fine, but maybe take a look at Amazon EC2 as well, it pairs very well with RDS.

[@shadyarbzharothman8689]

@@sabatino-dev Thanks

[@wilbertdune]

what app is this?

[@sabatino-dev]

It’s called Unipage, it’s a European food ordering system, with customers in Belgium, the Netherlands, France, …

[@amanprasadoo7]

Please make a tutorial for multi tenancy website please ❤

[@sabatino-dev]

Will add it to my idea list, thanks for the suggestion!

[@WellnessAndFitnessHub]

Hi, great video. How can I contact you?

[@sabatino-dev]

I started a discord community server at discord.gg/nTpQanKduF - feel free to join me there!

[@WellnessAndFitnessHub]

@@sabatino-dev I dropped a message

[@ifathere]

🎉❤❤

[@sabatino-dev]

🙏

[@Tyrus429]

Shared database approach is very risky thing. Better not to use it, unless you are dealing with something that is not very important.

[@sabatino-dev]

Not sure why you’d say that. Shared database is very popular and used by big players like Shopify, Stripe, OpenAI, Microsoft etc.

[@Tyrus429]

​@@sabatino-dev It comes with lot of cons, if some tenant want to delete their full data from dB, it requires a lot of efforts to only delete their data, also migration from one dB to another in case client wants is very tedious, and if client want to access their dB then also its very tough job. Maybe you know more than me about multi-tenant apps, but these are some of the major difficulties for small organizations to overcome.

[@IleniaQuintero]

Hello, I was looking at your video channel. We may be helping a company that uses secure images to increase supply chain security and help cloud native development. Would you be willing to help try their software, make a video, and help show devs how to use their tools? This is not an offer, but just to start a conversation about your willingness to take on sponsorship. Please provide me with your email if you are interested. You'd have a chance to look at their technology and decide if it's the type of software that you'd be interested in covering in your channel.

[@sabatino-dev]

You can reach out to [e-mail]