AWS Database Blog
The top 20 most-viewed Amazon DynamoDB documentation pages in 2019
The following 20 pages were the most viewed Amazon DynamoDB documentation pages in 2019. I have included a brief description with each link to explain what each page covers. Use this list to see what other AWS customers have been viewing and perhaps to pique your own interest in a topic you’ve been meaning to explore. […]
Best practices for upgrading Amazon RDS to major and minor versions of PostgreSQL
This post was last reviewed and update June, 2022 to update the upgrade steps for Amazon RDS. Open-source PostgreSQL occasionally releases new minor and major versions that include fixes for frequently encountered bugs, security issues, and data corruption problems. Generally, Amazon RDS aims to support new engine versions within five months of their availability. You […]
Amazon DynamoDB–related videos and slide decks from AWS re:Invent 2019
This blog post includes links to videos and slide decks of the keynotes and Amazon DynamoDB–related sessions from AWS re:Invent 2019. Video recordings were not made of workshops, chalk talks, and builders sessions. As of the publication of this post, not all of the slide decks are available for download, but we will update this […]
Securing Amazon RDS and Aurora PostgreSQL database access with IAM authentication
AWS provides two managed PostgreSQL options: Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. Both support IAM authentication for managing access to your database. You can associate database users with IAM users and roles to manage user access to all databases from a single location, which avoids issues caused by permissions being out of sync […]
2019: The year in review for Amazon DynamoDB
Last updated: December 17, 2019 2019 has been another busy year for Amazon DynamoDB. We have released new and updated features that focus on making your experience with the service better than ever in terms of reliability, encryption, speed, scale, and flexibility. The following 2019 releases are organized alphabetically by category and then by dated […]
Migrating databases using RDS PostgreSQL Transportable Databases
April 2023: This post was reviewed and updated with a new section on Limitations Amazon Relational Database Service (Amazon RDS) for PostgreSQL now supports the feature Transportable Databases, a high-speed data import and export method supported on versions 11.5 and later and 10.10 and later. If you need to import a PostgreSQL database from one […]
Amazon DocumentDB (with MongoDB compatibility) re:Invent 2019 recap
The Amazon DocumentDB team had a great time meeting with many of you at AWS re:Invent 2019, listening to your feedback and use cases, and understanding what you want us to build next. For me, the highlights of re:Invent were the two great customer use cases presented by FINRA and Fulfillment by Amazon (FBA). Both […]
Implementing cross-region disaster recovery using Oracle GoldenGate for Amazon RDS for Oracle
Many AWS users take advantage of the managed service offerings available in the AWS portfolio to do the heavy lifting in their day-to-day activities. Amazon RDS is one of these services and is ideal for your relational database deployments. With RDS, you can significantly reduce the administrative overhead of managing and maintaining a relational database. […]
Retain more for less with UltraWarm for Amazon Elasticsearch Service
September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. Machine-generated data powers solutions and causes problems. It’s indispensable for identifying operational issues in today’s modern software applications, yet you need flexible, scalable tools like Amazon Elasticsearch Service to analyze it in real time. This log data is so valuable […]
Dive into new functionality for PostgreSQL 11
In this post, I take a close look at three exciting features in PostgreSQL 11: partitioning, parallelism, and just-in-time (JIT) compilation. I explore the evolution of these features across multiple PostgreSQL versions. I also cover the benefits that PostgreSQL 11 offers, and show practical examples to point out how to adapt these features to your applications.