Row-level transformations in Postgres CDC using Lua

PeerDB Streams has introduced support for row-level transformations as part of Postgres Change Data Capture (CDC). Users can write simple Lua scripts to define a transformation and add it as part of the replication. This feature allows seamless in-flight row-level transformations to Postgres data before it is streamed to the target, addressing various use cases such as masking PII data, changing data format, generated columns, unnesting JSONs, topic routing, and data encryption. PeerDB chose Lua for its balance of engineering speed, integration with their Go-based platform, and end-user usability.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.