Posted by ramasankar august 15 2018 april 4 2020 posted in aws aws lambda postgresql python.
Aws lambda ruby postgres.
Amazon aurora serverless postgresql can now be accessed using the built in data api enabling you to access aurora serverless with web services based applications.
In this post i would like to show an example of lambda to connect to postgresql database and execute the query.
In particular you can access aurora easily from aws lambda aws appsync and aws cloud9.
My lambda function uses this library to access data stored in an postgresql rds instance.
Postgresql on aws lambda ruby.
It is understandable that ami image does not include libraries such as psycopg2 it is the lambda function developer s job to include any.
It s been long time since i wrote a blog post.
Aws lambda to connect to postgresql and execute a function query using python.
Ever since aws announced that ruby was now available on lambdas i have been looking at porting over my ror code to lambdas to see if i can save money instead of running ec2 instances.
Ruby in aws lambda with postgresql nokogiri 28 december 2018 by steven ringo running ruby based lambda functions with binary dependencies can be a bit tricky because aws lambda expects the packages with a specific structure and because included binaries must be built and packaged to work for the lambda operating environment.
While working on a personal project for setting up a basic data pipeline described here i ran into an issue where psycopg2 library was not available on aws lambda.