Re:Ask HN: How come there is no example code for B2B-SaaS apps?
by eloff on Sunday May 03, 2020 @09:45AM
(#23058945)
The limit is a lot higher than 2 to 5, but I think sooner or later it will get you. Until then you will suffer a slow death by a thousand migrations.
A separate database is best used if you need an absolute firewall between the tenants for security reasons. Almost no bug can ever let one tenant see the data from another. If they share tables, it's easier to make that mistake.
The downside is you can't have quieres across all your tenants, so you'll want a BI database that brings all the data together anyway.
A separate database is best used if you need an absolute firewall between the tenants for security reasons. Almost no bug can ever let one tenant see the data from another. If they share tables, it's easier to make that mistake.
The downside is you can't have quieres across all your tenants, so you'll want a BI database that brings all the data together anyway.