AWS Database Blog

A common coding strategy is to have multiple application servers attempt to insert the same data into the same table at the same time and rely on the database unique constraint to prevent duplication. The “duplicate key violates unique constraint” error notifies the caller that a retry is needed. This seems like an intuitive approach, […]

In this post, we walk you through an example of how you can use Amazon Keyspaces (for Apache Cassandra) with Amazon Elastic Container Service (Amazon ECS) to modernize your existing Cassandra workloads. These services use open standards that allow customers to migrate their existing workloads to take advantage of these services’ fully managed capabilities and […]

Financial services industry (FSI) customers and other highly regulated industries often need to audit every action made by each database user and administrator as well as identify each person logged in to their databases, usually using their identity provider (IdP). In such cases, the IdP is considered the source of truth for mapping users against […]

Do you want to copy or archive your Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition logs directly to Amazon Simple Storage Service (Amazon S3)? Does your organization have the regulatory requirements to audit all the DDL or DML activity against your RDS for PostgreSQL database? With the addition of […]

Today, we’re introducing the Amazon Database Migration Accelerator (DMA) Connect program which is designed to help you migrate from Amazon Relational Database Service (Amazon RDS) for Oracle to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL. Migration to Amazon RDS for Oracle is a common first step for many customers making their foray into […]

Amazon Timestream is a purpose-built time series database service you can use for IoT data collection, application health and usage monitoring, real-time analytics, and network performance monitoring. Timestream is fast, scalable, and serverless, making it easy and cost-effective to store and analyze trillions of events per day. Since its general availability in 2020, Timestream has […]

This is a guest blog post by Mukesh Mishra, IT Architect at HP Inc. HP Inc’s vision is to create technology that makes life better for every customer and partner, and we strive hard to simplify the customer experience across product lines and services. HP offers a broad portfolio of printers across different customer segments, […]

This is a guest post by Jeremy Welch, Data Software Engineer Sr. Staff on the Cloud, Data Management And Governance team with Panasonic Avionics Corporation, in partnership with AWS Sr. Database Solutions Architect Saikat Banerjee and Sr. Partner SA (Database) Venkatesh Periyathambi. Panasonic Avionics Corporation (PAC) is the world’s leading supplier of in-flight entertainment and […]

July 2023: This post was reviewed for accuracy. Babelfish for Aurora PostgreSQL understands T-SQL, Microsoft SQL Server’s proprietary SQL dialect, and supports the same communications protocol, so your applications that were originally written for SQL Server can now work with Amazon Aurora PostgreSQL-Compatible Edition with fewer code changes. With Babelfish, you still have to migrate […]

Amazon DocumentDB (with MongoDB compatibility) is a scalable, highly durable, and fully managed database service for operating mission-critical MongoDB workloads. We recently announced support for AWS Graviton2 instances for Amazon DocumentDB. AWS Graviton2 processors are custom built by AWS using 64-bit Arm Neoverse cores and feature always-on, fully encrypted DDR4 memory and 50% faster per-core […]