There are more AWS SDK examples available in the [AWS Doc SDK Examples](https://github.com/awsdocs/aws-doc-sdk-examples) GitHub repo. # Scenarios for Aurora using AWS SDKs The following code examples show you how to implement common scenarios in Aurora with AWS SDKs. These scenarios show you how to accomplish specific tasks by calling multiple functions within Aurora or combined with other AWS services. Each scenario includes a link to the complete source code, where you can find instructions on how to set up and run the code. Scenarios target an intermediate level of experience to help you understand service actions in context. **Topics** + [Create a lending library REST API](aurora_example_cross_AuroraRestLendingLibrary_section.md) + [Create an Aurora Serverless work item tracker](aurora_example_cross_RDSDataTracker_section.md) # Create a lending library REST API The following code example shows how to create a lending library where patrons can borrow and return books by using a REST API backed by an Amazon Aurora database. ------ #### [ Python ] **SDK for Python (Boto3)** Shows how to use the AWS SDK for Python (Boto3) with the Amazon Relational Database Service (Amazon RDS) API and AWS Chalice to create a REST API backed by an Amazon Aurora database. The web service is fully serverless and represents a simple lending library where patrons can borrow and return books. Learn how to: + Create and manage a serverless Aurora database cluster. + Use AWS Secrets Manager to manage database credentials. + Implement a data storage layer that uses Amazon RDS to move data into and out of the database. + Use AWS Chalice to deploy a serverless REST API to Amazon API Gateway and AWS Lambda. + Use the Requests package to send requests to the web service. For complete source code and instructions on how to set up and run, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/python/cross_service/aurora_rest_lending_library). **Services used in this example** + API Gateway + Aurora + Lambda + Secrets Manager ------ # Create an Aurora Serverless work item tracker The following code examples show how to create a web application that tracks work items in an Amazon Aurora Serverless database and uses Amazon Simple Email Service (Amazon SES) to send reports. ------ #### [ .NET ] **SDK for .NET** Shows how to use the AWS SDK for .NET to create a web application that tracks work items in an Amazon Aurora database and emails reports by using Amazon Simple Email Service (Amazon SES). This example uses a front end built with React.js to interact with a RESTful .NET backend. + Integrate a React web application with AWS services. + List, add, update, and delete items in an Aurora table. + Send an email report of filtered work items using Amazon SES. + Deploy and manage example resources with the included AWS CloudFormation script. For complete source code and instructions on how to set up and run, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/dotnetv3/cross-service/AuroraItemTracker). **Services used in this example** + Aurora + Amazon RDS + Amazon RDS Data Service + Amazon SES ------ #### [ C\$1\$1 ] **SDK for C\$1\$1** Shows how to create a web application that tracks and reports on work items stored in an Amazon Aurora Serverless database. For complete source code and instructions on how to set up a C\$1\$1 REST API that queries Amazon Aurora Serverless data and for use by a React application, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/cpp/example_code/cross-service/serverless-aurora). **Services used in this example** + Aurora + Amazon RDS + Amazon RDS Data Service + Amazon SES ------ #### [ Java ] **SDK for Java 2.x** Shows how to create a web application that tracks and reports on work items stored in an Amazon RDS database. For complete source code and instructions on how to set up a Spring REST API that queries Amazon Aurora Serverless data and for use by a React application, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/javav2/usecases/Creating_Spring_RDS_Rest). For complete source code and instructions on how to set up and run an example that uses the JDBC API, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/javav2/usecases/Creating_rds_item_tracker). **Services used in this example** + Aurora + Amazon RDS + Amazon RDS Data Service + Amazon SES ------ #### [ JavaScript ] **SDK for JavaScript (v3)** Shows how to use the AWS SDK for JavaScript (v3) to create a web application that tracks work items in an Amazon Aurora database and emails reports by using Amazon Simple Email Service (Amazon SES). This example uses a front end built with React.js to interact with an Express Node.js backend. + Integrate a React.js web application with AWS services. + List, add, and update items in an Aurora table. + Send an email report of filtered work items by using Amazon SES. + Deploy and manage example resources with the included AWS CloudFormation script. For complete source code and instructions on how to set up and run, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/javascriptv3/example_code/cross-services/aurora-serverless-app). **Services used in this example** + Aurora + Amazon RDS + Amazon RDS Data Service + Amazon SES ------ #### [ Kotlin ] **SDK for Kotlin** Shows how to create a web application that tracks and reports on work items stored in an Amazon RDS database. For complete source code and instructions on how to set up a Spring REST API that queries Amazon Aurora Serverless data and for use by a React application, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/kotlin/usecases/serverless_rds). **Services used in this example** + Aurora + Amazon RDS + Amazon RDS Data Service + Amazon SES ------ #### [ PHP ] **SDK for PHP** Shows how to use the AWS SDK for PHP to create a web application that tracks work items in an Amazon RDS database and emails reports by using Amazon Simple Email Service (Amazon SES). This example uses a front end built with React.js to interact with a RESTful PHP backend. + Integrate a React.js web application with AWS services. + List, add, update, and delete items in an Amazon RDS table. + Send an email report of filtered work items using Amazon SES. + Deploy and manage example resources with the included AWS CloudFormation script. For complete source code and instructions on how to set up and run, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/php/cross_service/aurora_item_tracker). **Services used in this example** + Aurora + Amazon RDS + Amazon RDS Data Service + Amazon SES ------ #### [ Python ] **SDK for Python (Boto3)** Shows how to use the AWS SDK for Python (Boto3) to create a REST service that tracks work items in an Amazon Aurora Serverless database and emails reports by using Amazon Simple Email Service (Amazon SES). This example uses the Flask web framework to handle HTTP routing and integrates with a React webpage to present a fully functional web application. + Build a Flask REST service that integrates with AWS services. + Read, write, and update work items that are stored in an Aurora Serverless database. + Create an AWS Secrets Manager secret that contains database credentials and use it to authenticate calls to the database. + Use Amazon SES to send email reports of work items. For complete source code and instructions on how to set up and run, see the full example on [GitHub](https://github.com/awsdocs/aws-doc-sdk-examples/tree/main/python/cross_service/aurora_item_tracker). **Services used in this example** + Aurora + Amazon RDS + Amazon RDS Data Service + Amazon SES ------