PostgREST serves a fully RESTful API from any existing PostgreSQL database.
CockroachDB promises distributed SQL advantages.
CockroachDB is built to be largely compatible with PostgreSQL. Here is a detailed blog on this
If we can bring these two together that's a powerful combination. We could automatically generate RESTful API for CockroachDB using PostgREST.
Is PostgREST compatible with CockroachDB ?
Has anyone used this combination on a production application ?
Like Steve Chavez commented, PostgREST is not currently compatible with CockroachDB since CockroachDB doesn't support SET LOCAL. See https://github.com/cockroachdb/cockroach/issues/32562#issuecomment-662105805 for more details.