This is how you beat Amazon/AWS, you go for the 40 percent where they fall behind in their products and make it better. They have a broad set of tooling not a particularly deep set of tooling.
Comparing AWS's RDS and PlanetScale
11–17 of 17 posts
Re: Comparing AWS's RDS and PlanetScale
#12Great comparison, but i feel like it would be fair to mention support for foreign key constraints in the overview table (which planetscale doesn‘t have, afaik)
Also no CTEs or window functions. More like MySQL 5.x support than 8.x.
https://vitess.io/docs/reference/compatibility/mysql-compati...
Re: Comparing AWS's RDS and PlanetScale
#13Great comparison, but i feel like it would be fair to mention support for foreign key constraints in the overview table (which planetscale doesn‘t have, afaik)
Also no CTEs or window functions. More like MySQL 5.x support than 8.x. https://vitess.io/docs/reference/compatibility/mysql-compati...
No transactions across shards is a bummer as well. Feels like planetscale might not be the best choice for small to medium projects, despite their improvements in developer experience.
Re: Comparing AWS's RDS and PlanetScale
#14The main issue that doesn't seem to be reflected here is that it's really hard to have a database and your application in different locations. Latency and security are big components in the general equation and both might be affected by this.
(This is the same reason why, although there are excellent Redis-as-a-service products, it's hard to justify to use them at all.)
Re: Comparing AWS's RDS and PlanetScale
#15Isn't Aurora a better apple to apple comparisonm
Re: Comparing AWS's RDS and PlanetScale
#16Earlier quoted context omitted.
Also no CTEs or window functions. More like MySQL 5.x support than 8.x. https://vitess.io/docs/reference/compatibility/mysql-compati...
No transactions across shards is a bummer as well. Feels like planetscale might not be the best choice for small to medium projects, despite their improvements in developer experience.
In practice this doesn't turn out to be a major issue, since a good design will keep >99% of queries/transactions on a single shard.
4 years of Vitess in prod, also a maintainer
Re: Comparing AWS's RDS and PlanetScale
#17The “Trusted by” page has some pretty impressive flagship companies (GitHub, Slack, Square, AirBnb). Is anyone familiar with the role in which Planetscale is used at those companies? (Unless that is advertising users of vitess vs the hosted offering).
I believe most of those are self-hosted Vitess with Planetscale providing technical resources and support.