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.
Aws lambda ruby postgres.
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.
Lambda project this is a command this is output for long commands an escape character is used to split a command over multiple lines on linux and macos use your preferred shell and package manager.
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.
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.
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.
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.
Aws lambda to connect to postgresql and execute a function query using python.
On windows 10 you can install the windows subsystem for linux to get a windows integrated version of ubuntu and bash.
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.