cockroachdb / cockroachdb/cockroach
cdc: allow database as changefeed target
- Vorherrschende Sprache
- Go
- Sterne
- 32.5k
- Forks
- 4.1k
- PR-Merge-Kennzahlen
- PR-Kennzahlen ausstehend
Beschreibung
**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
Beitragsleitfaden
Bewertung
Dieses Issue wurde noch nicht bewertet.