What databases have you worked with within the Amazon infrastructure?

In Amazon Web Services (AWS) infrastructure, the following databases are commonly used and can be worked with in Python:

• Amazon RDS — a managed relational database service (MySQL, PostgreSQL, SQL Server, etc.). Libraries such as psycopg2 for PostgreSQL or PyMySQL for MySQL can be used for interaction.

• Amazon DynamoDB — a NoSQL database with low latency. The AWS SDK — boto3 — is used in Python to work with it.

• Amazon Aurora — a high-performance relational database compatible with MySQL and PostgreSQL.

• Amazon Redshift — an analytical columnar database for big data.

Example of connecting to DynamoDB using boto3:

import boto3

dynamodb = boto3.resource('dynamodb', region_name='us-west-2')
table = dynamodb.Table('MyTable')

response = table.get_item(Key={'id': '123'})
item = response.get('Item')
print(item)

Thus, experience with AWS databases usually involves interacting with RDS, DynamoDB, and other services through the respective SDKs.