cockroachdb / cockroachdb/cockroach

cdc: allow database as changefeed target

Abierto
#93,793 1 comentario 0 reacciones 0 asignados Ver en GitHub
A-cdc C-enhancement T-cdc
Lenguaje dominante
Go
Estrellas
32.5k
Forks
4.1k
Métricas de merge de PR
Métricas de PR pendientes

Descripción

**Is your feature request related to a problem? Please describe.**

Users have expressed interest in create a changefeed for an entire database, instead of specific tables. In addition to being a convenience, I believe the intention is that new tables in said database will always be included in (added to) the changefeed.

**Describe the solution you'd like**

New syntax to have a changefeed for a database.

Question: is there a semantic distinction between a changefeed on a “database” vs “all tables in a database”? Depending on this answer, our syntax could be:

- `CREATE CHANGEFEED FOR DATABASE mydb`
- `CREATE CHANGEFEED FOR TABLE *` or `CREATE CHANGEFEED FOR TABLE mydb.*`

Or the `ALL` keyword in there somewhere.

We might also consider same for `SCHEMA`.

Edit, see also previous issue: https://github.com/cockroachdb/cockroach/issues/73435. I’ll still keep this issue open since it’s narrower.

Jira issue: CRDB-22530

Epic CRDB-1421

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.