rds-db-queries

RDS Database Queries

Key	Value
Services	RDS
Integrations	AWS CLI
Categories	Database

Introduction

A demo application illustrating running queries against an RDS database locally using LocalStack. The sample creates an RDS DB instance, executes SQL INSERT and SELECT queries, and cleans up the instance.

Prerequisites

• A valid LocalStack for AWS license. Your license provides a LOCALSTACK_AUTH_TOKEN to activate LocalStack.
• Docker
• localstack CLI
• awslocal CLI
• Python 3

Check prerequisites

make check

Installation

make install

Start LocalStack

export LOCALSTACK_AUTH_TOKEN=<your-auth-token>
make start

Run the application

make run

The script creates an RDS DB instance, runs queries to insert and retrieve records, and deletes the instance.

You should see output similar to:

Creating RDS DB instance
Run DB queries against RDS instance i1
[(1, 'Jane'), (2, 'Alex'), (3, 'Maria')]
Deleting RDS DB instance i1

License

This code is available under the Apache 2.0 license.