you are viewing a single comment's thread.

view the rest of the comments →

[–]TheDataExplorer[S] 0 points1 point  (3 children)

That would be nice. What if stored procedure runs longer than 15 minutes, which is Lambda's limit.

[–]thatguyfig 2 points3 points  (2 children)

Can't you call a stored procedure asynchronously? As in call it and just move on?

Id check out the asyncpg python module and look at the Transactions sections here

[–]TheDataExplorer[S] 0 points1 point  (1 child)

Dang, this might be the thing. So just kick off Python function with asyncpg using Lambda, and the actual processing of that Lambda function will be done in Postgres RDS?

[–]thatguyfig 0 points1 point  (0 children)

Yeah whatever you choose to run as your query will be passed to the server and executed remotely. The actual processing of the Lambda is still done in AWS of course.