Hacker News new | ask | show | jobs
by raylad 1717 days ago
Also no CTEs or window functions. More like MySQL 5.x support than 8.x.

https://vitess.io/docs/reference/compatibility/mysql-compati...
1 comments
vmaen 1717 days ago
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.
link
derekperkins 1709 days ago
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

link