5 ms·
I have no horse in this race, but CDC sounds more robust? It will capture all changes, regardless of how the application maintainers use the database.
by javier2 22d ago
I have no horse in this race, but CDC sounds more robust? It will capture all changes, regardless of how the application maintainers use the database.
- saxenaabhi 22d agoI prefer following: 1) CDC for archiving/recovery or as an audit log 2) downstream consumers consuming a business-events table. Kind of like inverted event-sourcing pattern. CDC is sound for sure but only in the lowest technically sense. Downstream consumers consuming business events gets you all the benefits of event sourcing(Namabilty, Replayability etc) while keeping relational guarantees and transactional safety.
- efromvt 22d agoOutbox events are my strict preference over CDC, but CDC was often easier. (Deal with the business logic downstream and all)
- karakanb 22d agoOne would think. Conceptually they are nice, practically it gets very dirty across different databases + all the infra around them. My dislike stems from the operational complexity and years of trauma around it.