How to Query RDS PostgreSQL from AWS Lambda in Java

In this tutorial, we will continue on in our series where we learn how to build serverless functions in AWS using Java. In this episode you will learn how to connect to an AWS RDS PostgreSQL database in a Lambda function using Java, query a table and return the results.

🔗Resources & Links mentioned in this video:

👋🏻Connect with me:

[garymarshall]

Very helpful. Looking forward to more AWS videos using AWS events. Thank you! Happy Holidays.

[AlgyTRG]

I've used JDBI to read/write to the DB from a lambda. It's really handy if the db operations are a little more complex.

[erickjhormanromero]

Thanks for this demo.
Let me add somenthing refering to the postgres dependency in production. using 42.2.23 version has many vulnerabilities and the lambda function works, and if you use 42.3.4 that also has one vulnerability the lamda function doesn't work, so finally using the 42.5.0 version that will work like a charm and even without any vulnerabilities .

[gyubinchoi]

If I want to add more functionalities like adding a new row, do I need to make a new maven project? Or do you recommend that I can add the new handler in the same project?

[mvlad]

Nice aws lambda java example. Need to research performance

[cesarcarpa]

Thanks for sharing, really appreciate it!

[JoseeRamirezz]

What is the name of the program you used to create the newsletter database?

[sourabhissourabh]

I am facing the CORS related issue while trying accessing spring cloud function through react. do you have any asistance for this

[TheCanay]

Thank you for such a great content! It's really help me to better understand labdas =)

[devanshpopli]

Please make more videos on Java Aws Lamda😇

[Bert-bxxp]

What is being used to provide support for named parameters -> name:"postgres"

[AleksandarT]

What is the difference between the proeprties java.version, maven.compiler.targer and maven.compier.source? Is there an option to have only one?

[samanshakya]

Please use video timestamps which will make navigation easier.

[randomboris]

I've read that putting the database password in the lambda's environment variable is not the best practice. Maybe you can show other more secure examples like using Secrets Manager to get the database credentials?