permify icon indicating copy to clipboard operation
permify copied to clipboard

use internal postgresdb datatypes and compatibility issue with cockroachdb.

Open mahmoudKheyrati opened this issue 2 years ago • 1 comments

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?

mahmoudKheyrati avatar Aug 04 '23 14:08 mahmoudKheyrati

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

tolgaozen avatar Aug 25 '23 11:08 tolgaozen