RisingWave reads directly from PostgreSQL, MySQL, and SQL Server using the Debezium Embedded Engine — no Kafka cluster, no Kafka Connect, no connector JSON. Replace a 6-component CDC pipeline with SQL.
| RisingWave | Debezium Standalone | |
|---|---|---|
| License | Apache 2.0 | Apache 2.0 |
| System category | Streaming database | CDC pipeline tool |
| Infrastructure required | RisingWave only | Kafka cluster + Kafka Connect + Schema Registry |
| CDC engine | Debezium Embedded Engine (in-process, no Kafka) | Debezium Connector (Kafka Connect plugin) |
| Query interface | SQL (PostgreSQL-compatible) | None (event stream only) |
| Transformations | SQL: filters, joins, aggregations, window functions | Single Message Transforms (SMT) — JSON config only, stateless |
| Materialized views | Yes, continuously maintained | Requires separate consumer (Flink, Spark, custom app) |
| Operational complexity | Low (single system, SQL configuration) | High (Kafka brokers, Connect workers, connector configs) |
| Learning curve | Shallow (standard SQL) | Steep (connector JSON, SMT config, Kafka operations) |
| Failure recovery | Instant (S3-backed checkpointed state) | Depends on Kafka cluster health and connector restart policy |
| Dynamic scaling | Transparent, no downtime | Requires Kafka partition and connector reconfiguration |
| Typical use cases | Real-time analytics, materialized views, streaming ETL | Fan-out CDC to multiple independent consumers |
| License | Apache 2.0 |
| System category | Streaming database |
| Infrastructure required | RisingWave only |
| CDC engine | Debezium Embedded Engine (in-process, no Kafka) |
| Query interface | SQL (PostgreSQL-compatible) |
| Transformations | SQL: filters, joins, aggregations, window functions |
| Materialized views | Yes, continuously maintained |
| Operational complexity | Low (single system, SQL configuration) |
| Learning curve | Shallow (standard SQL) |
| Failure recovery | Instant (S3-backed checkpointed state) |
| Dynamic scaling | Transparent, no downtime |
| Typical use cases | Real-time analytics, materialized views, streaming ETL |
Common questions about RisingWave CDC and how it compares to Debezium