Extension request: pg_net or http (webhooks)
I would better like to understand the likelihood of pg_net (or http) extensions making it into the Neon supported extensions list. I understand that with Neon's serverless nature most extensions aren't compatible by default and have to be adapted. Nevertheless, I would appreciate if someone on the Neon team could explain some of the challenges with implementing pg_net and paint a picture of how likely it is to become a feature. It is very useful to be able to extend the database using webhooks as the alternatives like having to set up elaborate database watchers or managing a stable database connection to listen to db notifications isn't particularly fun or easy and often overkill for basic one-way external service updates. Thanks for any replies 🫡
3 Replies
conscious-sapphire•3mo ago
Hey, @BoogeyMan!
pg_net is definitely on our roadmap. As you pointed out, it's pretty useful and we've seen a few requests like yours before.
We have a (mostly empty) epic for adding support here: https://github.com/neondatabase/neon/issues/5630. Some foundational work for it has been already merged here: https://github.com/neondatabase/neon/issues/3720.
Currently, the team is 100% focused on general reliability and performance work and unifying our infrastructure. I'll flag this internally to highlight interest in pg_net and will update here if I hear otherwise, but I'm pretty sure this won't happen in the next few months unfortunately.sunny-green•2mo ago
@Andre Landgraf can you share an update on this? Or can you provide an alternative way in neon to send db updates to an HTTP endpoint?
conscious-sapphire•2mo ago
Hey! No updates on this unfortunately. However, there are plenty of ways for you to send db updates to an HTTP endpoint other than
pg_net:
Check out:
- Neon's Inngest integration - trigger a background function every time you create/update/delete in Postgres
- Neon' Sequin integration - stream change events to a event system like Kafka, Pub/Sub, etc.Neon + Inngest: Trigger durable functions from database changes - I...
A new integration for Postgres database events
Neon
Stream changes from your Neon database to anywhere - Neon Docs
Neon's Logical Replication features makes it possible to detect every change in your database. It can be used to power read replicas and backups, but can also be used to add streaming characteristics ...