It finally supports them, which is nice. It doesn't support deferred checks to the commit, like postgres, but are otherwise good. I've appreciated using it to enforce json schema at the db level
Easily handled by adding a linter. Like you pointed out, that's an easy place to make mistakes, and this regularly catches them for us
https://github.com/nishanths/exhaustive
The activation process uses freemius, which is a joke. I've been trying to activate for 2 weeks and still haven't been able to get it working, and their support is a joke. No shade on the plugin itself, just the third party licensing provider. The free Simply Static has worked great.
It already does that. Click on the individual commit to only see those changes, then click next to continue. That's the only way I review commits, and it has been available for at least a few years
That matches many, if not most most real world workloads. When hotspots happen, you just continue to shard, as they don't have to be equally sized, even if you shard a single warehouse id to a dedicated node and vertically scale it up.
Vitess runs on actual MySQL, it's not just MySQL protocol compatible, so it's definitely closer. There aren't many queries you can't run on Vitess for a single shard, though distributed / multi-shard queries have more limitations