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 2 hours ago | parent [-]

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.

	▲	efromvt an hour ago \| parent [-]
		Outbox events are my strict preference over CDC, but CDC was often easier. (Deal with the business logic downstream and all)