Comparing AWS's RDS and PlanetScale

Re:Comparing AWS's RDS and PlanetScale by vmaen on Tuesday October 05, 2021 @12:02PM (#28761290)

Great 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)

[ Parent | on HN ]

Re:Comparing AWS's RDS and PlanetScale by raylad on Tuesday October 05, 2021 @11:31PM (#28768868)

Also no CTEs or window functions. More like MySQL 5.x support than 8.x.

https://vitess.io/docs/reference/compatibility/mysql-compati...

[ Parent | on HN ]

Re:Comparing AWS's RDS and PlanetScale by vmaen on Wednesday October 06, 2021 @04:30AM (#28770573)

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.

[ Parent | on HN ]

Re:Comparing AWS's RDS and PlanetScale by derekperkins on Wednesday October 13, 2021 @11:30AM (#28853433)

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

[ Parent | on HN ]

Re:Comparing AWS's RDS and PlanetScale by Scarbutt on Tuesday October 05, 2021 @12:45PM (#28761932)

Offensive to leave to that out ;)

"We make some things easier for developers but you will have to deal with concurrent updates in your application"

[ Parent | on HN ]