HNHacker News
TopNewBestAskShowJobs

enadzan

24 karma · joined June 21, 2020

A C# programmer:

  https://PgHook.com
  https://PgOutput2Json.net  
  https://MassiveJobs.net
  https://github.com/PgOutput2Json/PgFreshCache  
  https://github.com/XactJobs/XactJobs
submissionscomments
enadzan··on Show HN: PgHook – Docker image that streams PostgreSQL row changes to webhooks
I’ve added optional support for standard webhooks headers and the signature scheme in the latest version.
enadzan··on Show HN: PgHook – Docker image that streams PostgreSQL row changes to webhooks
Yes, but (as far as I understand) LISTEN/NOTIFY would require adding triggers to the tables I need to track. Also, if the PgHook container is down, NOTIFY events would be lost — for UI updates that’s not critical, but it’s a limitation.

I’ve been experimenting with logical replication [1] for a while, and it felt like a simpler fit here.

[1] https://github.com/PgOutput2Json/PgOutput2Json

enadzan··on Show HN: PgHook – Docker image that streams PostgreSQL row changes to webhooks
Thanks for checking it out! At this point I was focused on solving a specific problem, but improving compatibility is definitely worth looking into.
enadzan··on Show HN: PgOutput2Json .NET lib for PostgreSQL change streaming to JSON
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.