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:
Website: www.danvega.dev
Twitter: / therealdanvega
Github: github.com/dan...
LinkedIn: / danvega
Newsletter: www.danvega/de...
SUBSCRIBE TO MY CHANNEL: bit.ly/2re4GH0 ❤️

[@garymarshall7410]

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.

[@erickjhormanromero6905]

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 .

[@TheCanay]

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

[@mvlad7402]

Nice aws lambda java example. Need to research performance

[@Bert-bx9xp]

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

[@giovannifrison6941]

So cool Dan! so cool! keep going pls!

[@cesarcarpa7887]

Thanks for sharing, really appreciate it!

[@joshuaglickman1871]

Ty. Do I need individual lambdas for each database operation, like find, insert update, delete?

[@devanshpopli9982]

Please make more videos on Java Aws Lamda😇

[@samanshakya3848]

Please use video timestamps which will make navigation easier.

[@gyubinchoi7271]

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?

[@arghyamitra3281]

Pls keep going 😊

[@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

[@engalibadouin5222]

best video

[@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?

[@AleksandarT10]

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

[@erickjhormanromero6905]

java version refers to the desired java version in the compiler pluglin and it's formed by compiler.source and target. source is for the java version features that you need to use. that means that java version and target is for the compiled classes to be compatible with JVM 1.8. maven needs this to have a match with the java version and the code that you write. - and yes you can use this 8

[@hassanrady6134]

It's public db!!!