PlanetScale for Postgres now supports the wal2json extension, version 2.6.
wal2json is a logical decoding output plugin that produces JSON format change data capture (CDC) output. This extension enables streaming database changes in a structured JSON format, making it ideal for:
- Building change data capture pipelines
- Real-time data synchronization between systems
- Event-driven architectures that react to database changes
- Integration with stream processing platforms like Kafka
The extension uses PostgreSQL's logical decoding feature to capture row-level changes (INSERT, UPDATE, DELETE) and outputs them as JSON objects, providing a flexible and widely-compatible format for downstream consumers.