postgresql - Is it possible to execute a script to send web push notification on database(AWS Aurora PostgresSQL instance) change?

Question

I need to send web push notification on database changes in Amazon Aurora PostgresSQL instance.

I tried it locally and was able to send web push notification on db changes in PostgresSQL. For this I used webPush library and db executed a procedure written in plpython3u on db trigger. I want to replicate this behaviour on AWS side.

I found an approach in AWS doc that suggest that procedure stored in AWS Lambda gets executed on Aurora PostgresSQL changes but failed to find how to access the data from db, within that stored procedure in AWS Lambda. As for sending the web push notification we requires a subscription object and I want to get be his from table stored in the user table. I also went through this article but found the article heading to be misleading.

Is there any other solution by which we can send web push notification on db(AWS Aurora PostgresSQL instance) change?

question from:https://stackoverflow.com/questions/65843382/is-it-possible-to-execute-a-script-to-send-web-push-notification-on-databaseaws

Answer 1

Waitting for answers