AWS aurora-dsql documentation change
Summary
Updated documentation structure and content for Aurora DSQL PostgreSQL compatibility, including expanded details on supported features, core capabilities, and links to supported/unsupported features
Security assessment
Changes focus on feature compatibility and documentation reorganization without addressing security vulnerabilities or introducing security-specific content. No security implications identified in the diff.
Diff
diff --git a/aurora-dsql/latest/userguide/working-with.md b/aurora-dsql/latest/userguide/working-with.md index f8124062f..1b8f78f2f 100644 --- a//aurora-dsql/latest/userguide/working-with.md +++ b//aurora-dsql/latest/userguide/working-with.md @@ -7 +7 @@ Amazon Aurora DSQL is provided as a Preview service. To learn more, see [Betas a -# How Amazon Aurora DSQL works with PostgreSQL +# Aurora DSQL database features @@ -9 +9,33 @@ Amazon Aurora DSQL is provided as a Preview service. To learn more, see [Betas a -Aurora DSQL is a PostgreSQL-compatible database service. In the following sections, learn about Aurora DSQL support for PostgreSQL data types, features, and commands. +Aurora DSQL is PostgreSQL-compatible. For most supported features, Aurora DSQL and PostgreSQL provide identical behavior. Specifically, Aurora DSQL provides PostgreSQL compatibility as follows: + +**Identical query results for SQL features** + + +Supported SQL expressions return identical data in query results, including sort order, scale and precision for numeric operations, and equivalence for string operations. + +**Support for standard PostgreSQL drivers and compatible tools.** + + +In some cases, these tools require you to change the configuration. For a list of supported tools, see [ Utilities, tools, and sample code](https://docs.aws.amazon.com/aurora-dsql/latest/userguide/CHAP_tutorials-sample-code.html). To see code examples and other developer-related topics, see [Programming with Aurora DSQL](https://docs.aws.amazon.com/aurora-dsql/latest/userguide/programming-with.html). + +**Support for core relational features** + + +Core features include the following: + + * ACID transactions + + * Secondary indexes + + * Joins + + * Inserts + + * Updates + + + + +For an overview of supported SQL features, see [Supported SQL expressions](https://docs.aws.amazon.com/aurora-dsql/latest/userguide/working-with-postgresql-compatibility-supported-sql-features). + +Although Aurora DSQL maintains high PostgreSQL compatibility, advanced features and operations differ in important ways. For more information, see [ Unsupported PostgreSQL features](https://docs.aws.amazon.com/aurora-dsql/latest/userguide/working-with-postgresql-compatibility-unsupported-features). @@ -13 +45 @@ Aurora DSQL is a PostgreSQL-compatible database service. In the following sectio - * [PostgreSQL compatibility with Aurora DSQL](./working-with-postgresql-compatibility.html) + * [SQL feature compatibility in Aurora DSQL](./working-with-postgresql-compatibility.html) @@ -15 +47 @@ Aurora DSQL is a PostgreSQL-compatible database service. In the following sectio - * [Aurora DSQL connections](./working-with-connections.html) + * [ Connections in Aurora DSQL](./working-with-connections.html) @@ -17 +49 @@ Aurora DSQL is a PostgreSQL-compatible database service. In the following sectio - * [Aurora DSQL concurrency control ](./working-with-concurrency-control.html) + * [Concurrency control in Aurora DSQL](./working-with-concurrency-control.html) @@ -19 +51 @@ Aurora DSQL is a PostgreSQL-compatible database service. In the following sectio - * [Understanding data definition language (DDL) in Aurora DSQL](./working-with-ddl.html) + * [DDL and distributed transactions in Aurora DSQL](./working-with-ddl.html) @@ -23 +55 @@ Aurora DSQL is a PostgreSQL-compatible database service. In the following sectio - * [Creating async indexes in Aurora DSQL](./working-with-create-index-async.html) + * [Asynchronous indexes in Aurora DSQL](./working-with-create-index-async.html) @@ -25 +57 @@ Aurora DSQL is a PostgreSQL-compatible database service. In the following sectio - * [Using system tables and commands in Aurora DSQL](./working-with-systems-tables.html) + * [System tables and commands in Aurora DSQL](./working-with-systems-tables.html) @@ -38 +70 @@ Using database roles with IAM roles -PostgreSQL compatibility +SQL compatibility