permify
permify copied to clipboard
use internal postgresdb datatypes and compatibility issue with cockroachdb.
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?
Hi @mahmoudKheyrati, we are planning a development for CockroachDB; it's on our roadmap. We will update you soon 👍