alt Hacker NewsI 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.
Outbox events are my strict preference over CDC, but CDC was often easier. (Deal with the business logic downstream and all)