cockroachdb / cockroachdb/cockroach

cdc: allow database as changefeed target

Aperta
#93,793 1 commento 0 reazioni 0 assegnatari Vedi su GitHub
A-cdc C-enhancement T-cdc
Lingua principale
Go
Stelle
32.5k
Fork
4.1k
Metriche di merge delle PR
Metriche PR in attesa

Descrizione

**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

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.