SQL 123 🛢️ Change Data Capture (CDC) with Debezium and Database Triggers
Change Data Capture is the pattern of detecting row-level changes—inserts, updates, and deletes—as they happen, and streaming them to downstream systems. The two dominant approaches in relational databases are log-based CDC, which reads the database’s transaction log, and trigger-based CDC, which installs database triggers that write to an audit table. Debezium is the de-facto open-source…