Search code examples
postgresqlcockroachdbpostgrest

Can we use PostgREST with CockroachDB

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 ?

Solution

  • 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.