Using sqlx to decode pgoutput logical decoding messages

[tomas789]

Postgres has this nice mechanism called logical decoding. It allows you to retrieve any changes that were made in the database.

I'm using built-in (to Postgres) plugin pgoutput to read the binary messages which itself are described in Logical Replication Message Formats.

When a change in database occurs you get a datastructure called TupleData. It is very similar to what we have in PgRow in sqlx.

My question is: Can I somehow feed the TupleData to PgRow such that I can use the parsing mechanism in sqlx?

[tomas789]

Of course I'd like to do that without forking SQLx 😉

[CommanderStorm]

You can have a look at this PR #2924
=> CopyBoth is currently not a supported protocol and the PR is blocked on cancel safey reasons. If you have good ideas how to make this cancel-safe, a comment in said PR would be appreciated 😉