AWS Database Blog

Category: Intermediate (200)

Faster development with HAQM DynamoDB and HAQM Q Developer

HAQM Q Developer, a generative artificial intelligence (AI) assistant, can help accelerate the development of applications on AWS. In this post, we create a DynamoDB table using IaC then perform create, read, update, and delete (CRUD) operations on the table using Python and Boto3 (with additional observations for JavaScript and Java at the end of the post). We demonstrate how HAQM Q can improve your speed of development for these tasks.

Performing a minor version upgrade for HAQM RDS Custom for SQL Server CEV with Multi-AZ

In this post, we explain how to perform a database minor version upgrade (patch) with Multi-AZ on CEV instance, where RDS Custom performs rolling upgrades, so you have an outage only for failover period and the time needed for post-upgrade scripts until the instance is fully operational.

Schedule jobs in HAQM RDS or HAQM Aurora PostgreSQL using pg_tle and pg_dbms_job

Customers migrating Oracle databases to HAQM RDS for PostgreSQL or HAQM Aurora PostgreSQL might encounter the challenge of scheduling jobs that require precise sub-minute scheduling to avoid workflow disruptions and maintain business operations. In this post, we demonstrate how you can use Trusted Language Extensions (TLEs) for PostgreSQL to install and use pg_dbms_job on HAQM Aurora and HAQM RDS. pg_dbms_jobs allows you to manage scheduled sub-minute jobs.

Optimizing costs on HAQM DocumentDB using event-driven architecture and the AWS EventBridge Terraform module

A primary reason companies move their workloads to AWS is because of cost. With AWS, cloud migration and application modernization plans are based on your business needs and not agreements or licensing. You can acquire technology on an as-needed basis, only paying for the resources you use. You can build modern, scalable applications on AWS […]

Build and deploy knowledge graphs faster with RDF and openCypher

HAQM Neptune Analytics now supports openCypher queries over RDF graphs. When you build an application that uses a graph database such as HAQM Neptune, you’re typically faced with a technology choice at the start: There are two different types of graphs, Resource Description Framework (RDF) graphs and labeled property graphs (LPGs), and your choice of […]

Monitor HAQM DynamoDB operation counts with HAQM CloudWatch

HAQM DynamoDB continuously sends metrics about its behavior to HAQM CloudWatch. Something I’ve heard customers ask for is how to get a count of successful requests of each operation type (for example, how many GetItem or DeleteItem calls were made) in order to better understand usage and costs. In this post, I show you how to retrieve this metric.

Better Together: HAQM SageMaker Canvas and RDS for SQL Server, a predictive ML model sample use case

As businesses strive to integrate AI/ML capabilities into their customer-facing services and solutions, they often face the challenge of leveraging massive amounts of relational data hosted on on-premises SQL Server databases. This post showcases how HAQM Relational Database Service (HAQM RDS) for SQL Server and HAQM SageMaker Canvas can work together to address this challenge. By leveraging the native integration points between these managed services, you can develop integrated solutions that use existing relational database workloads to source predictive AI/ML models with minimal effort and no coding required.

Review your HAQM Aurora and HAQM RDS security configuration with Prowler’s new checks

Prowler for AWS provides hundreds of security configuration checks across services such as HAQM Redshift, HAQM ElasticCache, HAQM API Gateway, HAQM CloudFront, and many more. In this post, we focus on these new and expanded HAQM RDS security checks, their integration with AWS Security Hub, and the benefits they offer AWS users.

Query RDF graphs using SPARQL and property graphs using Gremlin with the HAQM Athena Neptune connector

To query a Neptune database in Athena, you can use the HAQM Athena Neptune connector, an AWS Lambda function that connects to the Neptune cluster and queries the graph on behalf of Athena. In this post, we provide a step-by-step implementation guide to integrate the new version of the Athena Neptune connector and query a Neptune cluster using Gremlin and SPARQL queries.