Can we get support for aws-lambda postgres extension?
Invoking an AWS Lambda function from an RDS for PostgreSQL DB insta...
Invoke an AWS Lambda function from an RDS for PostgreSQL DB instance.
9 Replies
ambitious-aqua•2y ago
This one seems tricky to support as we don't run the database inside of your AWS account. There would have to be some permission setup necessary. I think we also don't currently allow external network access from extensions, but I'll let someone else confirm that.
I'm curious, what use case do you have for such an extension?
I think we also don't currently allow external network access from extensionsActually, we allow external access for initiating logical replication subscriptions, so I think this is no longer a restriction.
fascinating-indigoOP•2y ago
I want to create postgres triggers that runs lamda function.
ambitious-aqua•2y ago
Ah, I see. That is fairly reasonable. I'll have to ask around
fascinating-indigoOP•2y ago
Thank you!
While I was trying to implement this using Auruora RDS, it looks like a lot of work really. What do you think about pg_net instead?
So instead of going the aws_lambda route, this looks simpler/easier and cleaner to implement
fascinating-indigoOP•2y ago
Postgres Triggers | Supabase Docs
Automatically execute SQL on table events.
fascinating-indigoOP•2y ago
Database Webhooks | Supabase Docs
Trigger external payloads on database events.
fascinating-indigoOP•2y ago
The webhook is just the trigger with pg_net
I'm already able to create function and triggers but the trigger can not make HTTP request
ambitious-aqua•2y ago
Ok, looks like we can't yet support this extension, but it is on the roadmap. Estimated timeline is currently around March/April
fascinating-indigoOP•2y ago
Thank you for the help @Conrad Ludgate