PlanetScale for Postgres

I used PlanetScale or a year or two before switching to Neon. I needed 1 database per tenant and PlanetScale didn't support that (you had to pay $30/mo per database, now it looks like $39/mo). My use-case is weird and I also don't need powerful servers (in fact I'd just as well prefer to run multiple databases on 1 server, I don't have a noisy-neighbor problem in my business). Neon let me do that but I couldn't on PS.

I get it, I'm a small fish trying to pay a little as possible for fully managed postgres (or MySQL before I switched to Postgres when I moved to Neon) to run my small, bootstrapped company with spiky [0] but fairly predictable load.

Best of luck to PlanetScale with this new offering, one day I hope I can use them again. I enjoyed the product and the support was great.

[0] I write software for food festivals, 9 months out of the year there is no traffic, ~2 months of the year there is a tiny trickle, ~3 weeks seeing high (but not "high" by any definition) and then 1-5 days (depending on how long the event is) there is a good deal of load but still not more than the lowest tier can handle most of the time. Like I said, I'm a _small_ fish and I don't expect them to cater to me, I just know what I want and almost no one provides it directly.

> I needed 1 database per tenant

...Depending on how many tenants that is, Turso may fit your use case.

https://turso.tech/

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.