Is there some compliance reason or otherwise that you need one physical database per tenant, and can't just colocate multiple logical databases/schemas on one PlanetScale database?
That's kind of hard to do with the PlanetScale schema migration concept (branching). Doing something like prefixed tables doesn't work and you can't create multiple databases on 1 server (or at least you couldn't and I did ask support about it).
I could make my application multi-tenant in the application code but that would require a lot of refactoring and testing. It's possible but it's a big lift to do that. If I could do that, I'd have much more flexibility. I don't think compliance will ever be an issue for me so that isn't holding me back.
I could make my application multi-tenant in the application code but that would require a lot of refactoring and testing. It's possible but it's a big lift to do that. If I could do that, I'd have much more flexibility. I don't think compliance will ever be an issue for me so that isn't holding me back.