temporalio / temporalio/temporal

Official CockroachDB (CRDB) support

Open
#4,180 1 comment 23 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
Go
Stars
23.2k
Forks
1.9k
Avg merge
2d 8h
Merged PRs (30d)
228

Description

Currently CRDB is working well with Temporal and the PostgreSQL v9.6 DB backend. But as e.g. https://github.com/temporalio/temporal/issues/4136 has shown, this was more accidental, although Temporal even provides a Docker Compose template that uses it.

We'd like to see CRDB becoming officially supported. The least I'd consider required for this is

  • SQL scripts either work for CRDB too or alternative scripts are provided
  • at least a subset of tests are run against CRDB in CI

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Review the existing PostgreSQL v9.6 SQL scripts and the Docker Compose template that uses CockroachDB, then inspect how database backends are exercised in CI. Confirm which scripts work on CRDB or identify where alternatives are needed, and define a CI job running at least a subset of tests against CRDB.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
ci-cd, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.