Debezium vs pgstream
Debezium
debezium.iopgstream
xata.ioSide by side
| Figure | Debezium | pgstream |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | — |
| macOS | — | Yes |
| Linux | Yes | Yes |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Change Data Capture Software | 8.9 (#2) | 7.9 (#11) |
| Deployment | The most common deployment uses Apache Kafka Connect; Debezium can also be embedded in JVM applications or run through Debezium Server. | pgstream can run as a standalone CLI or be embedded as a Go library, and requires PostgreSQL as a dependency. |
| License | All Debezium project code is licensed under the Apache License 2.0. | The project is licensed under Apache License 2.0. |
| Purpose | Debezium is an open source distributed platform for change data capture that streams database row changes to applications. | pgstream is an open-source CDC tool for replicating PostgreSQL data and DDL schema changes to targets. |
| Support | The project points users to its documentation, user chat room, and Google Group for questions. | The project README directs users with questions or issues to open a GitHub issue for community assistance. |
Plans
In their own words
Debezium
Debezium captures row-level database changes and delivers them to applications as events, so they can respond to inserts, updates, and deletes. Its connectors use database logs for low-delay capture without requiring changes to the data model, and can take initial or incremental snapshots, filter schemas, tables, and columns, and mask selected values. Listed databases include MongoDB, MariaDB, MySQL, PostgreSQL, SQL Server, Oracle, Db2, and Cassandra. Connectors for Vitess, Spanner, Informix, CockroachDB, YashanDB, Ingres, and Milvus are marked incubating and may change without backward compatibility. A common deployment uses Apache Kafka Connect; Debezium can also run through Debezium Server or as a library in JVM applications. Debezium Server can send serialized events to Amazon Kinesis, Google Cloud Pub/Sub, and Apache Pulsar. Ready-to-use transformations support routing, filtering, and event flattening. Debezium is free under the Apache Software License 2.0. Its quay.io container images are for testing and evaluation, not production.
pgstream
pgstream is a free, open-source tool for moving PostgreSQL data and schema changes to other systems. Run it as a command-line program or embed it as a Go library; it is self-hosted and requires PostgreSQL. Destinations include PostgreSQL, Elasticsearch or OpenSearch, Kafka, and webhooks. It can take an initial or on-demand snapshot for bulk loads and point-in-time copies, and tracks schema changes so receiving systems can reflect table updates. During replication, column values can be transformed with greenmask, neosync, go-masker, or custom transformers, including to mask production data headed for development or staging. Kafka support includes schema-based partitioning. Installation options include a Go binary, building from source, and Homebrew on macOS or Linux. The project uses the Apache License 2.0 and costs nothing. Its initial release has constraints: one Kafka topic, the wal2json PostgreSQL plugin, no row-level filtering, and a primary-key or unique non-null column requirement. Community questions and issues go through GitHub issues.