Hi HN, we're excited to share our open source tool with the community! Inquery is a utility for Postgres that triggers webhooks when rows are inserted, updated, or deleted. It uses database triggers that send low-latency websocket messages to a Go application. This application then calls any configured webhooks with a JSON payload that includes specified values from the database row. Let us know if you have any feedback or questions! |
Regarding the cloud option, we'd likely take a usage-based approach to pricing. Not sure if that would be based on number of events, actions, or some combination of the two. When we do offer this, we'll make sure that the free tier is generous and easy for small projects to use without worrying about paying.
1. Split the payload into chunks of 8k bytes and send them as separate messages to the server (in progress, will be released in the next few days).
2. Use a new table as an event queue where the trigger will write data and our server will consume it. We do want to incorporate an event queue soon so this approach would solve for that as long as users are ok with the system writing to a new table.
3. Use one of the Postgres logs to stream events instead of LISTEN/NOTIFY.
Let me know if you have thoughts on any of these approaches!
hopefully this isn't detracting too much from Inquery's product, which looks great, but I thought it's worth flagging - https://supabase.com/docs/guides/database/webhooks
We played around with Database Webhooks in Supabase and really liked the experience!
Feel free to reach out if there's anything we can help with