Hacker News Reader

What are the remaining use cases for CockroachDB where there isn't a better/open-source alternative?

multi-master writes with serializable transactions

FoundationDB

AFAIK more of a document store unless you use mvsqlite

The architecture is ingenious, though.

Does not have a SQL API (or something similar). The record layer is interesting but requires your application to be build in Java.

TiDB