AWS Database Blog

Category: Advanced (300)

Migrate SQL Server to Babelfish for Aurora PostgreSQL using the Compass tool and AWS DMS

Many AWS customers are starting to modernize architectures and move toward open-source databases. Babelfish for Aurora PostgreSQL makes it easier to migrate applications from SQL Server to Amazon Aurora PostgreSQL-Compatible Edition. With Babelfish, Aurora PostgreSQL-Compatible supports commonly used T-SQL language and semantics, which reduces the amount of code changes related to database calls in an […]

Import Ethereum private keys to AWS KMS

In the world of digital assets, private keys have always been of utmost importance. Unlike traditional assets, digital assets are controlled by private keys (a string of letters and numbers), just like passwords, which unlock the right to manage and use assets. Private keys can be used to irreversibly transfer funds from the wallet, thus, […]

How Zalando migrated their shopping carts to Amazon DynamoDB from Apache Cassandra

This post is co-written with Holger Macht and Mike Matsumoto from Zalando. Zalando is a leading European online shop for fashion and lifestyle. Founded in Berlin in 2008, Zalando brings head-to-toe fashion to over 50 million active customers, offering clothing, footwear, accessories, and beauty supplies. The assortment of international brands ranges from world-famous names to […]

Run Ethereum nodes on AWS

Amazon Managed Blockchain and many partners of AWS offer a convenient way to use Ethereum nodes without operating your own infrastructure. But sometimes, when you want to run archive nodes or participate in Ethereum staking, the managed nodes aren’t enough, and you may choose to run your own Ethereum nodes on AWS. To run a […]

Configure Amazon Aurora PostgreSQL database activity streams for monitoring in IBM Guardium

In this post, we guide you through the steps to setting up Amazon Aurora PostgreSQL-Compatible Edition database activity streams (DAS) for monitoring in IBM Guardium. Here, we are using IBM Guardium version 11.5. Aurora PostgreSQL-Compatible is a fully managed, PostgreSQL-compatible, ACID-compliant relational database engine that combines the speed, reliability, and manageability of Amazon Aurora with […]

Implement auto-increment with Amazon DynamoDB

When developing an application with Amazon DynamoDB, sometimes you want new items inserted into a table to have an ever-increasing sequence number. Some databases call this auto-increment and automatically populate the value on insert. Example use-cases could be giving a customer order or a support ticket a numeric identifier. DynamoDB doesn’t provide auto-increment as an […]

Cross-account Amazon RDS for Oracle migration using Amazon RDS snapshots and AWS DMS for minimal downtime

In scenarios such as consolidating or merging multiple departments with separate AWS accounts into a single AWS account, splitting a single account or divisions into multiple AWS accounts for better management, or duplicating an AWS account across Regions, you often need to migrate the database from one AWS account to another with minimal downtime and […]

Gain insights from Web3 data with The Graph and Amazon Managed Blockchain

Analyzing data originating on a blockchain can be a challenging and time-consuming process due to the complexity and variety of smart contract structures. This primary obstacle requires an in-depth understanding of the various platforms you wish to analyze. In the Web3 space, each protocol has their own way of storing and calling methods, making implementation […]

Migrate a cross-account TDE-enabled Amazon RDS for Oracle DB instance with reduced downtime using AWS DMS

Migrating a Transparent Data Encryption (TDE)-enabled Amazon Relational Database Service (Amazon RDS) for Oracle database instance from one AWS account to another is a common use case in scenarios when you acquire, sell, or merge operations, or if you’re reorganizing your AWS accounts and organizational structure. TDE is a permanent and persistent option in RDS […]

Implement a CI/CD pipeline for Ethereum smart contract development on AWS – Part 2

This post discusses the implementation details of an Ethereum smart contract CI/CD pipeline as outlined in a previous post, which is considered a prerequisite to the topics discussed in this post. Part 1 highlighted some of the challenges faced by a multi-developer team implementing a decentralized application (dApp) and how CI/CD can help address those […]