I was working on this for the past week. I needed a way to trigger background tasks when rows get inserted or updated in the DB, for an existing application that does not have insert/modification timestamps.

I used Npgsql that has replication support to implement it as a general-purpose library for dotnet-core.

I looked at wal2json decoding plugin to see how different types are handled. I could have used wal2json but I wanted to do it without the need to install anything extra to Postgres. Also, this way I have more control over JSON format.