14
Add native support for Cockroach DB
C
Cpaczek
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.
Aurélien Georget
open
Derrick Mehaffy
in progress
PR in progress by a community member (revived previously closed PR)
Derrick Mehaffy
The contributor who was working on this has decided to drop it for now, if anyone else wants to pick up where they left off here is the PR: https://github.com/strapi/strapi/pull/12346
J
James
After adding a collection-type using cockroach as the datastore I'm getting:
{
method: 'raw',
sql: '\n' +
' SELECT\n' +
' kcu."constraint_name" as constraint_name,\n' +
' kcu."column_name" as column_name\n' +
'\n' +
' FROM information_schema.key_column_usage kcu\n' +
' WHERE kcu.constraint_name=ANY(?)\n' +
' AND kcu.table_schema = ?\n' +
' AND kcu.table_name = ?;\n' +
' ',
bindings: [
[ [ 'up_users_updated_by_id_fk', 'up_users_created_by_id_fk' ] ],
'public',
'up_users'
],
options: {},
__knexQueryUid: 'odi333HIGM1hCJin7ctLF'
}
[2022-08-28 20:14:33.563] debug: ⛔️ Server wasn't able to start properly.
[2022-08-28 20:14:33.567] error:
SELECT
kcu."constraint_name" as constraint_name,
kcu."column_name" as column_name
FROM information_schema.key_column_usage kcu
WHERE kcu.constraint_name=ANY($1)
AND kcu.table_schema = $2
AND kcu.table_name = $3;
- error in argument for $1: unimplemented: 2-dimension arrays not supported; only 1-dimension
error:
SELECT
kcu."constraint_name" as constraint_name,
kcu."column_name" as column_name
FROM information_schema.key_column_usage kcu
WHERE kcu.constraint_name=ANY($1)
AND kcu.table_schema = $2
AND kcu.table_name = $3;
- error in argument for $1: unimplemented: 2-dimension arrays not supported; only 1-dimension