Amazon Aurora Serverless PostgreSQL Now Supports Data API

Posted on: Sep 24, 2019

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. In particular, you can access Aurora easily from AWS Lambda, AWS AppSync, and AWS Cloud9.

The Data API enables you to focus on building your applications without worrying about managing database connections or connection pools. Instead, you can issue SQL commands against an Aurora Serverless cluster by simply invoking a HTTPS API endpoint provided by the Data API. The Data API takes care of managing database connections and returning data.

Since the Data API leverages database credentials stored in AWS Secrets Manager, you don’t need to pass credentials in API calls. For customers using AWS Lambda, the Data API provides a secure way to access your database without the additional overhead for Lambda functions to be launched in an Amazon VPC. Integration with the AWS SDK provides programmatic interface to execute SQL statements with parameters, transaction execution, and batch updates. For more information, including instructions on getting start with Data API, read the documentation.

The Data API is available in US East (N. Virginia), US East (Ohio), US West (Oregon), Europe (Ireland), and Asia Pacific (Tokyo) Regions. It supports both PostgreSQL-compatible and MySQL-compatible Aurora Serverless databases.

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. You can learn more about Amazon Aurora by visiting the product page.