AWS Database Blog

How to sign Ethereum EIP-1559 transactions using AWS KMS

Ethereum is a popular public blockchain that enables you to create decentralized applications across a variety of use cases. In 2020 and 2021, it became widely used for decentralized finance (DeFi) apps and non-fungible token (NFT) apps. Due to its permissionless nature, it’s available to every user by just setting up an Ethereum account. These […]

Integrate Amazon RDS Custom for Oracle with Amazon EFS

As customers migrate their Oracle databases to the AWS Cloud, they often need a shared file system to be available on their Oracle database systems either to share files between the database and application servers or as a staging location to keep backups, data loads, and more. Amazon RDS Custom automates database administration tasks and […]

Amazon DynamoDB session videos from AWS re:Invent 2021

Amazon DynamoDB is a fully managed NoSQL database service that delivers single-digit millisecond performance at any scale and is used by many of the world’s most demanding applications. This blog post recaps the keynotes and breakout sessions that featured DynamoDB at AWS re:Invent 2021, including links to watch the videos on-demand. The 10th annual conference […]

Part 2: Audit Aurora PostgreSQL databases using Database Activity Streams and pgAudit

Many organizations these days have a mandate to comply with database regulatory and compliance requirements. Storing and using relevant metadata for these requirements has become extremely important. This is the second of a two-part post. In Part 1, we discussed two approaches to audit Amazon Aurora PostgreSQL-Compatible Edition databases: the Database Activity Streams feature and […]

Part 1: Audit Aurora PostgreSQL databases using Database Activity Streams and pgAudit

In light of today’s burgeoning data growth, the need for storing, sharing, protecting, and using data is becoming more challenging and complicated. Many enterprise organizations have mandates to comply with database regulatory and compliance requirements, which are of paramount importance. Storing relevant data from an auditing standpoint is another important requirement. In this post, we […]

Combine Amazon Neptune and Amazon OpenSearch Service for geospatial queries

Many AWS customers are looking to solve their business problems by storing and integrating data across a combination of purpose-built databases. The reason for that is purpose-built databases provide innovative ways to build data access patterns that would be challenging or inefficient to solve otherwise. For example, we can model highly connected geospatial data as […]

Optimize data archival costs in Amazon DocumentDB using rolling collections

Amazon DocumentDB (with MongoDB compatibility) is a scalable, highly durable, and fully managed database service for operating mission-critical MongoDB workloads. Amazon DocumentDB emulates the responses that a client expects from a MongoDB server by implementing the Apache 2.0 open-source MongoDB 3.6, 4.0 or 5.0 APIs on a purpose-built, distributed, fault-tolerant, and self-healing storage system that […]

Transform column content and data type using AWS DMS

AWS Database Migration Service (AWS DMS) is a managed service that you can use to migrate data from various source data engines to supported targets. When migrating data from an Oracle source to PostgreSQL-compatible target, you often encounter special data type transformation scenarios that require using the rich set of transformation rules AWS DMS provides. […]

Migrate SQL Server to Amazon Aurora PostgreSQL using best practices and lessons learned from the field

Many organizations are benefiting from the performance gains and ease of administration of the Amazon Aurora database platform. The idea of breaking free from commercial licenses, backup administration, and data center maintenance is always a welcome thought. But where to begin, and how complex is the journey to migrate from SQL Server to Amazon Aurora […]

Planning I/O in Amazon Aurora

June 2023: For Aurora databases where IO is greater than 25% of your costs, check out this blog post and recent announcement to see if you can save money with Aurora I/O-Optimized. Amazon Aurora combines the performance and availability of commercial databases with the simplicity and cost-effectiveness of open-source databases. An Aurora cluster consists of […]