29 ms·

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 P

• joshstrange 1y ago
  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.