[vmaen]

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)

[raylad]

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

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

[vmaen]

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.

[derekperkins]

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

[Scarbutt]

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"