I propose that CockroachDB should be added as a supported database to Strapi v4. Currently knex 0.95.12 (v4 is on .0.95.6) officially supports CockroachDB as a dialect.
I think it should be added for the following reasons
Great scaling on Kubernetes
One command automatic backups to s3
Multi-Master nodes
Amazing diagnostics admin panel
We were able to get CockroachDB to work on v3 using Postgres config however we have yet to test v4 with Cockroach but I will be editing this issue with any updates.
Created by Derrick Mehaffy
August 19, 2022