A Python DB-API 2.0 client for the AWS Aurora Serverless Data API
Project description
# aurora-data-api - A Python DB-API 2.0 client for the AWS Aurora Serverless Data API
Installation
pip install aurora-data-api
Prerequisites
Set up an [AWS Aurora Serverless cluster](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html) and enable Data API access for it. If you have previously set up an Aurora Serverless cluster, you can enable Data API with the following AWS CLI command:
aws rds modify-db-cluster --db-cluster-identifier DB_CLUSTER_NAME --enable-http-endpoint --apply-immediately
Save the database credentials in [AWS Secrets Manager](https://docs.aws.amazon.com/secretsmanager/latest/userguide/intro.html) using a format expected by the Data API (a JSON object with the keys username and password):
aws secretsmanager put-secret-value --secret-id MY_DB_CREDENTIALS --secret-string "$(jq -n '.username=env.PGUSER | .password=env.PGPASSWORD')"
Usage
Use this module as you would use any DB-API compatible driver module. The aurora_data_api.connect() method is the standard main entry point, and accepts two implementation-specific keyword arguments:
aurora_cluster_arn (also referred to as resourceArn in the Data API documentation)
secret_arn (the database credentials secret)
import aurora_data_api
cluster_arn = "arn:aws:rds:us-east-1:123456789012:cluster:my-aurora-serverless-cluster"
secret_arn = "arn:aws:secretsmanager:us-east-1:123456789012:secret:MY_DB_CREDENTIALS"
with aurora_data_api.connect(aurora_cluster_arn=cluster_arn, secret_arn=secret_arn, database="my_db") as conn:
with conn.cursor() as cursor:
cursor.execute("select * from pg_catalog.pg_tables")
print(cursor.fetchall())Motivation
The RDS Data API is the missing link between the AWS Lambda serverless environment and the sophisticated features provided by PostgreSQL and MySQL. The Data API tunnels SQL over HTTP, eliminating the need to use a traditional database driver
Links
Bugs
Please report bugs, issues, feature requests, etc. on GitHub.
License
Licensed under the terms of the Apache License, Version 2.0.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for aurora_data_api-0.0.1-py2.py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 801c33a1a2846a4ca643c6ad377a8dbb5f80f8addb36afbbaae3030400f7ebac |
|
| MD5 | 3947b94279f4e81de0c4df9ce3efc8fd |
|
| BLAKE2b-256 | bfd7df3fd63dabead19d0d4a7f0f2781e657c49b72057a8cd0a33c2ffd87bdf7 |
