Live data from Hacker News

Building PlanetScale with PlanetScale

planetscale.com

11–20 of 23 posts

Re: Building PlanetScale with PlanetScale

#11
post #5

Personally, migrations have never been painful enough to warrant this sort of product. The idea of branching databases on the other hand is really cool. Is each branch a full copy? Seems like that would lead to huge storage needs for larger databases.

Interesting, I'd be fascinated to hear what tech you use, because I've always had a really hard time with migrations.

Any migration scheme with a timestamp based approach is going to work well (e.g. ActiveRecord, TypeORM).

Re: Building PlanetScale with PlanetScale

#13
I've been a fan of PlanetScale and recently was able to chat[1] with their Head of Eng. Great team, better product execution. Also moved my personal site from using Firebase/Redis to just MySQL with PlanetScale[2] and the results have been solid. Averaging 128ms on function response times with a p95 of 250ms.

[1]: https://www.youtube.com/watch?v=YqBG5rFP4Ic

[2]: https://github.com/leerob/leerob.io/pull/326

Re: Building PlanetScale with PlanetScale

#15
This looks quite compelling, but what about use cases where "serverless" is simply not viable. In some industries, you must control access to the server in order to stay compliant with regulations. At least for some of the data. Is there a plan to have a software-only release? Or did I just miss it.

Re: Building PlanetScale with PlanetScale

#18
post #8
post #6

Earlier quoted context omitted.

I had the impression they PS was interesting because they offer serverless SQL.

I've been PlanetScale for a test drive recently, and it's a bit of both. I also think they kind of go hand-in-hand: if you have "serverless" things (or just Docker), they can come and go with connections very quickly, so picking the correct "pause time" to take the DB down for an ALTER TABLE is possible but a tiny bit awkward. Online migrations mean you never take it down and it's always available so that's kind of m…

> So you have no foreign keys

What other differences are there vs MySQL in terms of data modeling?

Re: Building PlanetScale with PlanetScale

#19
post #15

This looks quite compelling, but what about use cases where "serverless" is simply not viable. In some industries, you must control access to the server in order to stay compliant with regulations. At least for some of the data. Is there a plan to have a software-only release? Or did I just miss it.

We won't be doing software only releases or on prem software for PlanetScale. We do have an option to provision into your own cloud account so that the data lives inside your environment and you get all the PlanetScale magic.
Post reply on HN