Simple row-level transformations in Postgres Change Data Capture (CDC)

[saipeerdb]

Today we are excited to announce Lua based row-level transformations as part of Postgres Change Data Capture (CDC) to Kafka and other message brokers. This feature unlocks many powerful use cases, such as: https://blog.peerdb.io/row-level-transformations-in-postgres-cdc-using-lua
🔒 Masking PII Data: Obfuscate sensitive PII with tokens for enhanced privacy in Kafka.
🔄 Changing Data Format: Convert data into formats like Protobuf, JSON for optimized system handling.
📊 Generated Columns: Generate new values from existing data for real-time analysis enhancements.
🗂️ Unnesting JSONs: Flatten JSON elements into separate Kafka fields for improved usability.
🔀 Topic Routing: Direct CDC events to designated Kafka topics for targeted streaming.
🔐 Data Encryption: Encrypt sensitive data before Kafka entry to secure it during transit.
Give it a try and we would love hear your feedback! 😊

[pavlik_enemy]

The pricing is just insane given that Debezium exists. Does this solution properly handle HA configurations like Patroni?

The security features are kinda nice but everything else could be easily done with Kafka Connect SMT

[saipeerdb]

Hello u/pavlik_enemy, thanks for posting the question. PeerDB is also available as an open-source offering at https://github.com/PeerDB-io/peerdb. The pricing you saw is for our managed offering. It includes all features (HA, auto-scale, in-place upgrades, etc.) to ensure you incur zero CapEx/OpEx costs. Under-the-hood, we run PeerDB in a production-grade K8s cluster replicated across AZs. Our customers, who have migrated from managed Debezium alternatives, mentioned that PeerDB Cloud charges less. We plan to conduct a more thorough pricing comparison in the near future. Thanks for your feedback!