what is the best way to host tenants? in shared or isolated dB?
i'm working on multi-tenant application and i am trying to figure out whether tenants should be hosted in a shared dB(with tenant IDs) or in saperate databases.. can anybody tell me which one would be better and why? I would love insights from people who have dealt with multi-tenant architectures in prodiuction :)