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.
2 comments
[ 4.4 ms ] story [ 19.5 ms ] threadI 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.