4 ms·
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 data
by joshstrange 1y ago
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.
- x-complexity 1y ago> I needed 1 database per tenant ...Depending on how many tenants that is, Turso may fit your use case. https://turso.tech/ https://turso.tech/
- blerb795 1y agoIs 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?
- joshstrange 1y agoThat'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.