CockroachDB Support

[EricDotSmith]

It would be great to have CockroachDB support. This DB allows for tons of high availability low latency queries with regional databases in a cluster and global tables.

Is support for this in the pipeline?

[Vishtar]

It is planned: Public Roadmap

[ecosse3]

+1. Support would be great.

[neondeex]

+1

[Firgrep]

+1

[below-1]

+1

[AdityaBorkar]

+1

[theg1239]

+1

[CyberClarence]

+1

[siyamhosan]

+1

[blagoySimandov]

+1

[julianarchila]

+1

[Elmosh]

Any progress yet?

[chaoticvibe]

+1

[Brahmarishi]

+1

[bluepuma77]

Just tested Drizzle ORM with CockroachDB. Interestingly I can create a database tables on first run, but I can't upgrade it. Second npm run db:push will always fail:

Using 'postgres' driver for database querying
[⣻] Pulling schema from database...
PostgresError: could not parse "{int,int8,int2}" as type regtype[]: could not parse "int" as type oid: strconv.ParseInt: parsing "int": invalid syntax
    at ErrorResponse (file:///proj/node_modules/postgres/src/connection.js:794:26)
    at handle (file:///proj/node_modules/postgres/src/connection.js:480:6)
    at TLSSocket.data (file:///proj/node_modules/postgres/src/connection.js:315:9)
    at TLSSocket.emit (node:events:507:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '22P02',
  file: 'datum.go',
  line: '291',
  routine: 'MakeParseError'
}

Funny enough there are no integers in my schema, only text and timestamps. Just thought that I leave this here in case you want to slowly add some compatibility.

And serial('id').primaryKey() doesn't really work, at least you can't declare it as integer reference.

"drizzle-kit": "^0.31.4",
"drizzle-orm": "^0.44.2",

[lkwr]

First-party support for CockroachDB is coming in #4439