3 ms·
I like your event sourcing approach. I was recently looking into YugabyteDB changde data capture and it quickly became apparent that cdc can be used for exactly
by rad_gruchalski 5y ago
I like your event sourcing approach. I was recently looking into YugabyteDB changde data capture and it quickly became apparent that cdc can be used for exactly that. I wrote about It here: https://gruchalski.com/posts/2022-02-23-yugabytedb-change-data-capture/ https://gruchalski.com/posts/2022-02-23-yugabytedb-change-da....
One problem with the cdc approach is not having a way to monitor ddl operations. However, at least in any Postgres capable database with extensions support, it’s pretty easy to either: use pg_audit or write a rudimentary extension for ddl streaming.
- WinterMount223 5y agoDDL transactions should be committed orders of magnitude less frequently than data transactions, so it’s reasonable to separate their logging.
- rad_gruchalski 5y agoInterestingly enough, the new CDC SDK in YugabyteDB 2.13 supports DDL statements as well: https://github.com/yugabyte/yugabyte-db/blob/398a2b1a460ed8f79b03245b6cd2c36c622e439f/src/yb/cdc/cdc_service.proto#L320-L330 https://github.com/yugabyte/yugabyte-db/blob/398a2b1a460ed8f....