alt Hacker NewsI 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.
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.
I 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.