search

Permify / permify

An open-source authorization as a service inspired by Google Zanzibar, designed to build and manage fine-grained and scalable authorization systems for any application.
https://docs.permify.co/
Apache License 2.0
4.73k stars 208 forks source link

use internal postgresdb datatypes and compatibility issue with cockroachdb. #605

Open mahmoudKheyrati opened 1 year ago

mahmoudKheyrati commented 1 year ago

I want to use cockroachdb instead of postgresdb as a writeDB to achieve NewSql advantages(high availability, high throughput, fault-tolerance and ... ) . cockroachDB has compatible with postgres drivers. according to my reviews I found out that transaction table schema (storage/postgres/migrations/initial.sql) uses xid8 and pg_snapshot witch are internal datatypes of postgres and cockroachdb doesn't support and compatible with these datatypes. if I want to use alternative types what is your suggestions?

tolgaOzen commented 1 year ago

Hi @mahmoudKheyrati, we are planning a development for CockroachDB; it's on our roadmap. We will update you soon 👍