In this talk I'll explore the AWS feature to access the relational Amazon Aurora Serverless v2 (PostgreSQL) database over HTTP with Data API that frees us from managing the database connection on our own which is not a trivial task for the short-lived Lambda functions. I will use AWS SDK for Java to explore the different flavours of Data API: (batch) statement execution and working with database transactions. I will also provide Data API performance metrics (for example making Data API call to Aurora Serverless v2 from AWS Lambda) and compare it with the metrics of other database session management solutions like RDS Proxy instead. I'll also discuss different performance optimization techniques including AWS SnapStart and priming to reduce the cold start of the Lambda function and Data API current constraints.

In this talk I'll explore the AWS feature to access the relational Amazon Aurora Serverless v2 (PostgreSQL) database over HTTP with Data API that frees us from managing the database connection on our own which is not a trivial task for the short-lived Lambda functions. I will use AWS SDK for Java to explore the different flavours of Data API: (batch) statement execution and working with database transactions. I will also provide Data API performance metrics (for example making Data API call to Aurora Serverless v2 from AWS Lambda) and compare it with the metrics of other database session management solutions like RDS Proxy instead. I'll also discuss different performance optimization techniques including AWS SnapStart and priming to reduce the cold start of the Lambda function and Data API current constraints.