Native Support for Google Cloud Spanner

[NOT-HAL9000]

I'm wondering if you have considered adding Google Cloud Spanner support for OpenFGA?

It has global strong transactional consistency, extremely performant, 99.999 SLA, and it has zero downtime schema changes (everything you want for OpenFGA). It is also more cost effective to run spanner than it is to run Cloud SQL (Much cheaper to run ever since Spanner changed their pricing model - $65 dollars a month for about 1k reads / second and 200 writes / second with no downtime upgrades for more).

We are thinking of using OpenFGA with cloud spanner through the PGAdapter (postgres adapter), which is possible because it supports pgx connections, however that is extra overhead and we would love it if it was possible to use spanner with openfga without any sidecar proxy adapter infra to manage.

Spanner + OpenFGA work really well together

[aaguiarz-uy]

Hi @NOT-HAL9000,

We have discussed it, but we don't have any concrete plans yet.

An additional alternative to the ones you mentioned above could be for you to write a Cloud Spanner OpenFGA adapter. It should not be hard to do, however, we can't guarantee that we'll include that as part of the OpenFGA binary.

[NOT-HAL9000]

Thanks @aaguiarz-uy. Unfortunately we don't have much go experience so we will just have to rely on the PGAdapter.

[dank303]

I'm in the same boat (wanting to use openfga with spanner database). I'm also attempting to use pgadapter, but have run across several issues with the openfga and goose migrations that have constructs not supported by that flow. Even that level of support (not using grpc) would be helpful.