It is understandable that ami image does not include libraries such as psycopg2 it is the lambda function developer s job to include any.
Aws lambda ruby postgres.
My lambda function uses this library to access data stored in an postgresql rds instance.
Aws lambda to connect to postgresql and execute a function query using python.
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.
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.
It s been long time since i wrote a blog post.
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.
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.
Everything is going well and i have been able to almost successfully run all of my gems except pg on the lambci lambda ruby2 5.
On windows 10 you can install the windows subsystem for linux to get a windows integrated version of ubuntu and bash.
Posted by ramasankar august 15 2018 april 4 2020 posted in aws aws lambda postgresql python.