Category: PostgreSQL compatible

Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL version 11 end of standard support is February 29, 2024. See the Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL announcements to upgrade your databases: Announcement: Amazon Aurora PostgreSQL 11.x end of support is February 29, 2024 Amazon RDS for PostgreSQL 11 […]

In a relational database management system, a unique key is a set of one or more attributes (columns) that uniquely identifies each row in a table. It ensures that no two rows in the table can have the same values for the specified attributes. The following are the features of a unique key: Uniqueness – […]

Migrating databases from Oracle to either Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL presents a unique challenge when migrating JSON data. Oracle CLOB data type can contain both well-formed and invalid JSON, whereas the PostgreSQL JSON and JSONB data type requires JSON data to be correctly formatted according to […]

This post was co-written with Rajesh Saluja, Principal Engineer at Intuit. Intuit is the global financial technology environment that powers prosperity for 100 million consumer and small business customers with TurboTax, Credit Karma, QuickBooks, and Mailchimp. Intuit has built on AWS since 2013 and has taken an “all-in” approach in its move to the cloud. […]

The typical migration process for an Oracle database to Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL requires both automated and manual procedures. The AWS Schema Conversion Tool (AWS SCT) can handle the automated duties of schema conversion. For specific database objects that can’t be automatically migrated, the manual duties […]

This is the first post of a two-part series. In this post, we discuss how to migrate SQL Server indexed views to materialized views in Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL. The second post in this series will walk you through the migration of SQL Server indexed views […]

Customers use semi-structured or unstructured data storage for various business use cases, which is schema-less and flexible in nature. One such type of semi-structured data is JavaScript Object Notation (JSON). JSON stores data in the form of KEY, VALUE, LIST, and ARRAY formats. Oracle Database stores JSON object data in CLOB data type columns. PostgreSQL […]

Traditionally, applications that communicate with relational databases use drivers that provide a persistent connection between the application and the database server. With the advent of serverless applications, including those created using AWS Lambda, persistent connections from the application are no longer practical because serverless applications are, by nature, stateless. What’s more, traditional database drivers often […]

Many organizations are often seeking to migrate from their commercial relational databases, such as Oracle, to open-source databases like PostgreSQL. When migrating from Oracle to PostgreSQL databases, the most time-consuming and complex part is converting database structures, code, and storage objects such as packages, procedures, functions, and triggers. Converting or modernizing from Oracle to Amazon […]

Applications often use an array of data to represent a business object containing multiple values. Many customers choose Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition to store their array of business data. There are several architectures available for saving array values to a PostgreSQL database. You need to consider […]