# DSQL

Amazon Aurora DSQL is a serverless distributed relational database service for transactional workloads.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## AWS positioned highest in Ability to Execute in new Gartner Magic Quadrant for Cloud Operational Database Management Systems

DevFeed: [AWS positioned highest in Ability to Execute in new Gartner Magic Quadrant for Cloud Operational Database Management Systems](<https://devfeed.tech/articles/aws-positioned-highest-in-ability-to-execute-in-new-gartner-magic-quadrant-for-cloud-operational-database-management-systems-144310.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/aws-positioned-highest-in-ability-to-execute-in-new-gartner-magic-quadrant-for-cloud-operational-database-management-systems/>)

Author: G2 Krishnamoorthy

Published: 2026-11-19T20:55:23Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [database-scalability](<https://devfeed.tech/topics/database-scalability.md>), [AI Integration Strategies](<https://devfeed.tech/topics/ai-integration-strategies.md>), [Managed Services](<https://devfeed.tech/topics/managed-services.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [active-active](<https://devfeed.tech/tags/active-active.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agentic-ai](<https://devfeed.tech/tags/agentic-ai.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-workflows](<https://devfeed.tech/tags/ai-workflows.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-dynamodb](<https://devfeed.tech/tags/amazon-dynamodb.md>), [amazon-elasticache](<https://devfeed.tech/tags/amazon-elasticache.md>), [amazon-web-services-aws](<https://devfeed.tech/tags/amazon-web-services-aws.md>), [apache-iceberg](<https://devfeed.tech/tags/apache-iceberg.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [database-management](<https://devfeed.tech/tags/database-management.md>), [foundational-100](<https://devfeed.tech/tags/foundational-100.md>), [gartner](<https://devfeed.tech/tags/gartner.md>), [gartner-magic-quadrant](<https://devfeed.tech/tags/gartner-magic-quadrant.md>), [leader](<https://devfeed.tech/tags/leader.md>), [operational](<https://devfeed.tech/tags/operational.md>), [operational-database](<https://devfeed.tech/tags/operational-database.md>), [thought-leadership](<https://devfeed.tech/tags/thought-leadership.md>)

### AI overview

AWS says Gartner named it a Leader in the Magic Quadrant for Cloud Operational Database Management Systems and placed it highest for Ability to Execute. The excerpt links operational database needs for AI applications to strongly consistent reads, transactions, idempotent writes and durable audit trails. It highlights Aurora for PostgreSQL/MySQL performance and global availability, Aurora DSQL for serverless active-active multi-Region strong consistency, DynamoDB for single-digit-millisecond performance and global tables, and ElastiCache for sub-millisecond caching and auditable requests. AWS also cites MCP connectivity, native vector search, and Aurora PostgreSQL querying Iceberg and Parquet in place. The excerpt promotes the full Gartner report as a resource for understanding its assessment criteria; it does not provide the report's detailed comparisons, and Gartner disclaims endorsing vendors or recommending selection by rating alone.

### Source excerpt

Amazon Web Services (AWS) has been named a Leader in the Gartner Magic Quadrant for Cloud Operational Database Management Systems and is positioned highest of all evaluated vendors for Ability to Execute.

## How to use Amazon Aurora DSQL audit logs

DevFeed: [How to use Amazon Aurora DSQL audit logs](<https://devfeed.tech/articles/how-to-use-amazon-aurora-dsql-audit-logs-141385.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/how-to-use-amazon-aurora-dsql-audit-logs/>)

Author: Koji Shinkubo

Published: 2026-11-18T21:33:01Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [audit](<https://devfeed.tech/topics/audit.md>), [Logging](<https://devfeed.tech/topics/logging.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [Tool](<https://devfeed.tech/topics/tool.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-athena](<https://devfeed.tech/tags/amazon-athena.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [athena](<https://devfeed.tech/tags/athena.md>), [audit](<https://devfeed.tech/tags/audit.md>), [audit-logging](<https://devfeed.tech/tags/audit-logging.md>), [audit-logs](<https://devfeed.tech/tags/audit-logs.md>), [configure](<https://devfeed.tech/tags/configure.md>), [database](<https://devfeed.tech/tags/database.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [field](<https://devfeed.tech/tags/field.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [logging](<https://devfeed.tech/tags/logging.md>), [logs](<https://devfeed.tech/tags/logs.md>), [post](<https://devfeed.tech/tags/post.md>), [query](<https://devfeed.tech/tags/query.md>), [records](<https://devfeed.tech/tags/records.md>), [requirements](<https://devfeed.tech/tags/requirements.md>), [s3](<https://devfeed.tech/tags/s3.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

Aurora DSQL audit logging records configured SQL statement classes and delivers records to S3; it is off until both a destination and recording settings are configured. The article describes role-based scope, including READ/SELECT, and a setup that separates audit administration from DBA permissions. Records can identify the IAM role and database role, transaction, statement, and optionally bound values and row counts. Athena can query the S3 logs, while CloudTrail connection events can be joined by session ID to add client IP information; transaction IDs can also link audit records to CDC changes. Limits and tradeoffs include potentially high log volume and charges, no table- or column-level scope, no client IP or success/failure field in audit records, and recording statements from rolled-back transactions. The article recommends testing scope and volume before production and protecting sensitive log content through access controls, encryption, and retention settings.

### Source excerpt

Amazon Aurora DSQL audit logging records the SQL statements that run in your database and delivers them to Amazon S3. This post shows how to configure audit logging to meet regulatory requirements, explains what each recorded field proves in an audit, and shows how to query the logs in Amazon S3 with Amazon Athena.

## Use query statistics to find slow and expensive queries in Aurora DSQL

DevFeed: [Use query statistics to find slow and expensive queries in Aurora DSQL](<https://devfeed.tech/articles/use-query-statistics-to-find-slow-and-expensive-queries-in-aurora-dsql-138653.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/use-query-statistics-to-find-slow-and-expensive-queries-in-aurora-dsql/>)

Author: Rakesh Reddy Kondakindi

Published: 2026-11-17T21:09:25Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [application](<https://devfeed.tech/tags/application.md>), [asynchronous](<https://devfeed.tech/tags/asynchronous.md>), [build](<https://devfeed.tech/tags/build.md>), [change](<https://devfeed.tech/tags/change.md>), [code](<https://devfeed.tech/tags/code.md>), [cost](<https://devfeed.tech/tags/cost.md>), [dpu](<https://devfeed.tech/tags/dpu.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [help](<https://devfeed.tech/tags/help.md>), [improvement](<https://devfeed.tech/tags/improvement.md>), [index](<https://devfeed.tech/tags/index.md>), [investigation](<https://devfeed.tech/tags/investigation.md>), [latency](<https://devfeed.tech/tags/latency.md>), [performance](<https://devfeed.tech/tags/performance.md>), [post](<https://devfeed.tech/tags/post.md>), [queries](<https://devfeed.tech/tags/queries.md>), [query](<https://devfeed.tech/tags/query.md>), [statistics](<https://devfeed.tech/tags/statistics.md>)

### AI overview

Aurora DSQL query statistics record per-statement calls, latency, rows returned and scanned, compute and storage time, and DPU use, complementing sampled DASH metrics. In the walkthrough, CloudWatch Database Insights and Query Studio identify an order-history query scanning about 5.17 million rows to return 20, taking about 12 seconds and 656 DPU per call. EXPLAIN ANALYZE VERBOSE confirms a missing customer_id index. Building an index asynchronously lets the query read matching rows in created_at order and stop after 20; measured latency falls below 3 ms and DPU use to 0.015 per call. Statement statistics must be enabled per cluster and, in multi-Region setups, for each peer cluster. The post's figures come from a reproducible test; its DPU cost example uses US West (Oregon) pricing.

### Source excerpt

When a code change slows your application, Amazon Aurora DSQL query statistics help you find the slow and expensive queries behind it, down to the exact SQL statement. This post walks through a performance investigation that pinpoints a missing index, fixes it with an asynchronous index build, and measures the improvement in latency and DPU cost.

## Build a serverless recipe-sharing API with Go and Amazon Aurora DSQL

DevFeed: [Build a serverless recipe-sharing API with Go and Amazon Aurora DSQL](<https://devfeed.tech/articles/build-a-serverless-recipe-sharing-api-with-go-and-amazon-aurora-dsql-131173.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/build-a-serverless-recipe-sharing-api-with-go-and-amazon-aurora-dsql/>)

Author: Steve Brown

Published: 2026-11-12T16:14:20Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [REST API](<https://devfeed.tech/topics/rest-api.md>), [Erlang](<https://devfeed.tech/topics/erlang.md>)

Tags: [amazon-api-gateway](<https://devfeed.tech/tags/amazon-api-gateway.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [aws-lambda](<https://devfeed.tech/tags/aws-lambda.md>), [cloudformation](<https://devfeed.tech/tags/cloudformation.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [distribution](<https://devfeed.tech/tags/distribution.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [go](<https://devfeed.tech/tags/go.md>), [iam](<https://devfeed.tech/tags/iam.md>), [integrity](<https://devfeed.tech/tags/integrity.md>), [intermediate-200](<https://devfeed.tech/tags/intermediate-200.md>), [keys](<https://devfeed.tech/tags/keys.md>), [optimistic-concurrency](<https://devfeed.tech/tags/optimistic-concurrency.md>), [recipe](<https://devfeed.tech/tags/recipe.md>), [referential-integrity](<https://devfeed.tech/tags/referential-integrity.md>), [rest-api](<https://devfeed.tech/tags/rest-api.md>), [retries](<https://devfeed.tech/tags/retries.md>), [serverless](<https://devfeed.tech/tags/serverless.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [token](<https://devfeed.tech/tags/token.md>), [uuid](<https://devfeed.tech/tags/uuid.md>)

### AI overview

The article demonstrates a Go recipe-sharing REST API that runs locally as a Gin HTTP server or on AWS Lambda behind API Gateway, using the same handlers and an Amazon Aurora DSQL store. It describes UUID text primary keys to spread writes across storage partitions; short-lived IAM tokens, TLS, and a pgx connection pool managed by the Go connector; and separate DDL operations because DDL and DML cannot share a transaction. The sample checks chef and recipe references in handlers, though the database can enforce them with foreign keys instead. Aurora DSQL optimistic concurrency conflicts can be retried by the connector's occretry package with exponential backoff, so transaction logic should be idempotent. Deployment uses a script and CloudFormation for Lambda, API Gateway, IAM, and logs; its IP allowlist is not authentication, and the article recommends adding an authorization method for production. The text also notes connection recycling before the 60-minute server limit and low pool sizing for single-request Lambda invocations.

### Source excerpt

Build a fully serverless recipe-sharing REST API in Go on Amazon Aurora DSQL, AWS Lambda, and Amazon API Gateway. Learn UUID primary keys for even write distribution, short-lived IAM token authentication, application-layer referential integrity, and automatic optimistic-concurrency retries, with a one-command CloudFormation deployment.

## Building a multi-tenant CRM with Amazon Aurora DSQL

DevFeed: [Building a multi-tenant CRM with Amazon Aurora DSQL](<https://devfeed.tech/articles/building-a-multi-tenant-crm-with-amazon-aurora-dsql-129582.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/building-a-multi-tenant-crm-with-amazon-aurora-dsql/>)

Author: Aishwarya Sawant

Published: 2026-11-11T21:16:45Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [tenant data protection](<https://devfeed.tech/topics/tenant-data-protection.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-elastic-container-service](<https://devfeed.tech/tags/amazon-elastic-container-service.md>), [aws-identity-and-access-management-iam](<https://devfeed.tech/tags/aws-identity-and-access-management-iam.md>), [crm](<https://devfeed.tech/tags/crm.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [ecs](<https://devfeed.tech/tags/ecs.md>), [proof-of-concept](<https://devfeed.tech/tags/proof-of-concept.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [tenancy](<https://devfeed.tech/tags/tenancy.md>), [tenant-isolation](<https://devfeed.tech/tags/tenant-isolation.md>)

### AI overview

The article's main security requirement is to derive tenant identity from a verified token claim and apply that tenant ID to every repository query. Its CRM proof of concept uses one shared schema with tenant_id on each tenant-scoped row; this is simple to onboard and scales with workload, but isolation depends on the application. Cluster-per-tenant offers stronger isolation at the cost of per-tenant endpoints, grants, and migrations; schema-per-tenant is limited by Aurora DSQL's current 10-schema maximum. The implementation uses UUID keys with tenant-leading indexes, application checks to ensure referenced accounts belong to the same tenant, and an IAM-authenticated connector with connections retired before the one-hour limit. Aurora DSQL requires separate transactions for DDL statements, while standalone indexes build asynchronously. Writes use optimistic concurrency control: transaction callbacks retry serialization conflicts and must be idempotent. Bulk writes should be batched to stay within the 3,000-row, 10 MiB, and five-minute transaction limits. The article also notes that Aurora DSQL does not support row-level security.

### Source excerpt

Learn how to design and implement a multi-tenant CRM on Amazon Aurora DSQL using the pooled tenancy model. Tenant isolation is enforced in a centralized data-access layer, with Aurora DSQL-specific design considerations, and a working proof of concept you can deploy on Amazon ECS Express Mode.

## Building Node.js applications with Sequelize ORM and Amazon Aurora DSQL

DevFeed: [Building Node.js applications with Sequelize ORM and Amazon Aurora DSQL](<https://devfeed.tech/articles/building-node-js-applications-with-sequelize-orm-and-amazon-aurora-dsql-87259.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/building-node-js-applications-with-sequelize-orm-and-amazon-aurora-dsql/>)

Author: Lasita Bhattacharya

Published: 2026-10-14T15:56:52Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Eloquent ORM](<https://devfeed.tech/topics/eloquent.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [aws](<https://devfeed.tech/tags/aws.md>), [concurrency-control](<https://devfeed.tech/tags/concurrency-control.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [iam](<https://devfeed.tech/tags/iam.md>), [node-js](<https://devfeed.tech/tags/node-js.md>), [optimistic-concurrency](<https://devfeed.tech/tags/optimistic-concurrency.md>), [orm](<https://devfeed.tech/tags/orm.md>), [retry-logic](<https://devfeed.tech/tags/retry-logic.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This tutorial builds a hotel reservation application using Sequelize ORM with Amazon Aurora DSQL. It explains PostgreSQL compatibility and connector setup, UUID keys and relationship modeling, IAM authentication, single-statement DDL, and optimistic concurrency retries with backoff. It also covers least-privilege access, TLS, networking, connection pooling, monitoring, and cleanup.

### Source excerpt

Node.js teams can run Sequelize ORM on Amazon Aurora DSQL with only a few adaptations. This post builds a hotel reservation application that shows reusable patterns: UUID primary keys, IAM authentication through the Aurora DSQL connector, individual DDL execution, and optimistic concurrency control retry logic.

## Monitor Amazon Aurora DSQL costs with the Aurora DSQL console and CloudWatch alarms

DevFeed: [Monitor Amazon Aurora DSQL costs with the Aurora DSQL console and CloudWatch alarms](<https://devfeed.tech/articles/monitor-amazon-aurora-dsql-costs-with-the-aurora-dsql-console-and-cloudwatch-alarms-86351.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/monitor-amazon-aurora-dsql-costs-with-the-aurora-dsql-console-and-cloudwatch-alarms/>)

Author: Tejas Dubey

Published: 2026-10-13T15:28:52Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [amazon-sns](<https://devfeed.tech/tags/amazon-sns.md>), [aws-cloudformation](<https://devfeed.tech/tags/aws-cloudformation.md>), [aws-command-line-interface-aws-cli](<https://devfeed.tech/tags/aws-command-line-interface-aws-cli.md>), [aws-identity-and-access-management-iam](<https://devfeed.tech/tags/aws-identity-and-access-management-iam.md>), [aws-management-console](<https://devfeed.tech/tags/aws-management-console.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [billing](<https://devfeed.tech/tags/billing.md>), [cli](<https://devfeed.tech/tags/cli.md>), [cloudwatch](<https://devfeed.tech/tags/cloudwatch.md>), [code](<https://devfeed.tech/tags/code.md>), [costs](<https://devfeed.tech/tags/costs.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [storage](<https://devfeed.tech/tags/storage.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This tutorial explains how to monitor Amazon Aurora DSQL usage and costs with its built-in console panel and CloudWatch. It walks through hourly DPU cost alarms with SNS notifications and shows how to deploy the monitoring setup using CloudFormation. The hourly alarm tracks individual hours rather than cumulative monthly spending; the article recommends AWS Budgets for month-to-date tracking.

### Source excerpt

As your Amazon Aurora DSQL workload scales, DPU consumption and storage costs can grow without a fixed instance ceiling. This post shows how to monitor Aurora DSQL usage and cost with the built-in Usage and cost panel, set up Amazon CloudWatch alarms for hourly DPU spend, and deploy the alarms as code with AWS CloudFormation.

## Migrate SSIS packages to Aurora PostgreSQL - Part 2

DevFeed: [Migrate SSIS packages to Aurora PostgreSQL - Part 2](<https://devfeed.tech/articles/migrate-ssis-packages-to-aurora-postgresql-part-2-66961.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/migrate-ssis-packages-to-aurora-postgresql-part-2/>)

Author: Suchindranath Hegde

Published: 2026-10-07T15:21:26Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [AWS Step Functions](<https://devfeed.tech/topics/aws-step-functions.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [Amazon EventBridge](<https://devfeed.tech/topics/amazon-eventbridge.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-eventbridge](<https://devfeed.tech/tags/amazon-eventbridge.md>), [aws-step-functions](<https://devfeed.tech/tags/aws-step-functions.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-compatible](<https://devfeed.tech/tags/postgresql-compatible.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This tutorial explains how to migrate complex SSIS packages to AWS using Step Functions to coordinate Lambda tasks, Map and Parallel states, and EventBridge scheduling. It also covers error handling, notifications, and operational tradeoffs, with Aurora PostgreSQL as the database target.

### Source excerpt

Part 2 of migrating SSIS packages to Amazon Aurora PostgreSQL tackles the complex packages. Learn how to replace SSIS control flow, Foreach Loop Containers, and Script Tasks with AWS Step Functions state machines, Map and Parallel states, and Lambda, and schedule them with Amazon EventBridge in place of SQL Server Agent.

## Assess and migrate SQL Server Full-Text Search to Babelfish for Aurora PostgreSQL

DevFeed: [Assess and migrate SQL Server Full-Text Search to Babelfish for Aurora PostgreSQL](<https://devfeed.tech/articles/assess-and-migrate-sql-server-full-text-search-to-babelfish-for-aurora-postgresql-65161.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/assess-and-migrate-sql-server-full-text-search-to-babelfish-for-aurora-postgresql/>)

Author: Anand Raghavan

Published: 2026-10-05T15:25:20Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [opensearch](<https://devfeed.tech/topics/opensearch.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-ec2](<https://devfeed.tech/tags/amazon-ec2.md>), [amazon-elastic-compute-cloud-amazon-ec2](<https://devfeed.tech/tags/amazon-elastic-compute-cloud-amazon-ec2.md>), [amazon-opensearch-service](<https://devfeed.tech/tags/amazon-opensearch-service.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [babelfish-for-aurora-postgresql](<https://devfeed.tech/tags/babelfish-for-aurora-postgresql.md>), [full-text-search](<https://devfeed.tech/tags/full-text-search.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-compatible](<https://devfeed.tech/tags/postgresql-compatible.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

A six-checkpoint guide assesses whether SQL Server Full-Text Search workloads can migrate to Babelfish for Aurora PostgreSQL. It identifies features that migrate directly, require custom PL/pgSQL functions, or need an alternative, and covers compatibility limits, language support, stopwords, catalogs, and behavior differences.

### Source excerpt

Migrating SQL Server Full-Text Search to Babelfish for Amazon Aurora PostgreSQL is one of the trickier parts of a migration. This post presents a six-checkpoint decision tree to assess whether your Full-Text Search workload can move to Babelfish, what migrates directly, what needs a custom function, and what requires an alternative approach.

## Deploy Oracle Database step by step on Amazon EVS with FSx for ONTAP

DevFeed: [Deploy Oracle Database step by step on Amazon EVS with FSx for ONTAP](<https://devfeed.tech/articles/deploy-oracle-database-step-by-step-on-amazon-evs-with-fsx-for-ontap-64216.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/architecture/deploy-oracle-database-step-by-step-on-amazon-evs-with-fsx-for-ontap/>)

Author: Satish Bhoi

Published: 2026-10-02T17:57:15Z

Content type: tutorial

Language: en

Sources: [AWS Architecture Blog](<https://devfeed.tech/sources/aws-architecture-blog.md>)

Topics: [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [Cloud and systems](<https://devfeed.tech/topics/cloud-and-systems.md>), [Amazon Elastic Block Store (Amazon EBS)](<https://devfeed.tech/topics/amazon-elastic-block-store-amazon-ebs.md>), [Oracle Database@AWS](<https://devfeed.tech/topics/oracle-database-aws.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [UniFi UNAS Pro](<https://devfeed.tech/topics/unifi-unas-pro.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-elastic-vmware-service-amazon-evs](<https://devfeed.tech/tags/amazon-elastic-vmware-service-amazon-evs.md>), [amazon-fsx-for-netapp-ontap](<https://devfeed.tech/tags/amazon-fsx-for-netapp-ontap.md>), [aws-datasync](<https://devfeed.tech/tags/aws-datasync.md>), [aws-identity-and-access-management-iam](<https://devfeed.tech/tags/aws-identity-and-access-management-iam.md>), [disaster-recovery](<https://devfeed.tech/tags/disaster-recovery.md>), [oracle-database](<https://devfeed.tech/tags/oracle-database.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [volumes](<https://devfeed.tech/tags/volumes.md>)

### AI overview

A step-by-step guide to deploying Oracle Database 19c on Amazon Elastic VMware Service with FSx for NetApp ONTAP. It covers Oracle VM provisioning, NFS datastore setup, cross-region SnapMirror disaster recovery, SnapCenter backups, migration options, and day-to-day recovery and cloning operations.

### Source excerpt

This post provides step-by-step procedures to deploy Oracle Database on Amazon Elastic VMware Service (Amazon EVS) with Amazon FSx for NetApp ONTAP as NFS datastore storage. You provision storage volumes, mount NFS datastores, install Oracle, and configure SnapMirror replication for cross-region disaster recovery.

## Working with foreign key constraints in Aurora DSQL

DevFeed: [Working with foreign key constraints in Aurora DSQL](<https://devfeed.tech/articles/working-with-foreign-key-constraints-in-aurora-dsql-63565.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/working-with-foreign-key-constraints-in-aurora-dsql/>)

Author: Rekha Reddy Anupati

Published: 2026-10-01T16:42:03Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [database-consistency](<https://devfeed.tech/topics/database-consistency.md>), [Distributed Systems & Parallel Computing](<https://devfeed.tech/topics/distributed-systems-parallel-computing.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [database](<https://devfeed.tech/tags/database.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [expert-400](<https://devfeed.tech/tags/expert-400.md>), [foreign-keys](<https://devfeed.tech/tags/foreign-keys.md>), [optimistic-concurrency](<https://devfeed.tech/tags/optimistic-concurrency.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This tutorial explains how Aurora DSQL supports foreign key constraints, including immediate and deferred enforcement, adding constraints to existing tables, and optimistic concurrency control. It also covers schema design for scale and retry handling for transaction conflicts.

### Source excerpt

Amazon Aurora DSQL supports foreign key constraints, letting you enforce referential integrity directly in the database. This post covers defining foreign keys, immediate versus deferred enforcement, adding constraints to existing tables, and how optimistic concurrency control resolves conflicts in distributed workloads.

## Migrate Db2 z/OS to Amazon Aurora PostgreSQL using AWS DMS and gateway server

DevFeed: [Migrate Db2 z/OS to Amazon Aurora PostgreSQL using AWS DMS and gateway server](<https://devfeed.tech/articles/migrate-db2-z-os-to-amazon-aurora-postgresql-using-aws-dms-and-gateway-server-62865.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/migrate-db2-z-os-to-amazon-aurora-postgresql-using-aws-dms-and-gateway-server/>)

Author: Pragnesh Patel

Published: 2026-09-30T16:45:26Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [AWS Database Migration Service](<https://devfeed.tech/topics/aws-database-migration-service.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-ec2](<https://devfeed.tech/tags/amazon-ec2.md>), [aws-database-migration-service](<https://devfeed.tech/tags/aws-database-migration-service.md>), [database-migration](<https://devfeed.tech/tags/database-migration.md>), [db2](<https://devfeed.tech/tags/db2.md>), [expert-400](<https://devfeed.tech/tags/expert-400.md>), [migration](<https://devfeed.tech/tags/migration.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-compatible](<https://devfeed.tech/tags/postgresql-compatible.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [z-os](<https://devfeed.tech/tags/z-os.md>)

### AI overview

The tutorial explains how to migrate and replicate data from an on-premises IBM Db2 database on z/OS to Amazon Aurora PostgreSQL using AWS DMS and a Db2 gateway server on Amazon EC2. It covers configuring the gateway and DMS resources, performing full loads with periodic refreshes, and validating synchronization.

### Source excerpt

Learn how to use AWS DMS and a Db2 gateway server on Amazon EC2 to migrate and replicate data from an on-premises IBM Db2 database on z/OS to Amazon Aurora PostgreSQL. This post covers configuring the gateway, creating DMS resources, running a full load with periodic full-load refresh, and validating the migration.

## Aurora PostgreSQL zero-ETL integration with Amazon SageMaker

DevFeed: [Aurora PostgreSQL zero-ETL integration with Amazon SageMaker](<https://devfeed.tech/articles/aurora-postgresql-zero-etl-integration-with-amazon-sagemaker-61707.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/big-data/aurora-postgresql-zero-etl-integration-with-amazon-sagemaker/>)

Author: Apurwa Pawar

Published: 2026-09-29T16:10:14Z

Content type: tutorial

Language: en

Sources: [AWS Big Data Blog](<https://devfeed.tech/sources/aws-big-data-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Amazon SageMaker](<https://devfeed.tech/topics/amazon-sagemaker.md>), [etl](<https://devfeed.tech/topics/etl.md>), [elt](<https://devfeed.tech/topics/elt.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Amazon Bedrock Knowledge Bases](<https://devfeed.tech/topics/amazon-bedrock-knowledge-bases.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-sagemaker](<https://devfeed.tech/tags/amazon-sagemaker.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [etl](<https://devfeed.tech/tags/etl.md>), [lakehouse](<https://devfeed.tech/tags/lakehouse.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This tutorial explains Aurora PostgreSQL zero-ETL integration with Amazon SageMaker. It describes how operational data is replicated to an AWS Glue catalog as Apache Iceberg tables for near-real-time analytics, covers the lakehouse architecture and change data capture mechanics, and outlines setup and querying in SageMaker.

### Source excerpt

Amazon Aurora PostgreSQL zero-ETL integration with Amazon SageMaker replicates your operational data to a lakehouse in near real time, without building custom ETL pipelines. Learn the architecture and change data capture mechanics, then set up the integration and query your data in Amazon SageMaker.

## AWS Introduces Foreign Key Constraints in Aurora DSQL

DevFeed: [AWS Introduces Foreign Key Constraints in Aurora DSQL](<https://devfeed.tech/articles/aws-introduces-foreign-key-constraints-in-aurora-dsql-60810.md>)

Original publisher: [Read original article](<https://www.infoq.com/news/2026/09/aurora-dsql-foreign-keys/>)

Author: Renato Losio

Published: 2026-09-28T04:54:00Z

Content type: news

Language: en

Sources: [InfoQ](<https://devfeed.tech/sources/infoq.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [database-consistency](<https://devfeed.tech/topics/database-consistency.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-ml-data-engineering](<https://devfeed.tech/tags/ai-ml-data-engineering.md>), [architecture-design](<https://devfeed.tech/tags/architecture-design.md>), [aurora-dsql-foreign-keys](<https://devfeed.tech/tags/aurora-dsql-foreign-keys.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [development](<https://devfeed.tech/tags/development.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [distributed-data](<https://devfeed.tech/tags/distributed-data.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [ml-data-engineering](<https://devfeed.tech/tags/ml-data-engineering.md>), [news](<https://devfeed.tech/tags/news.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql-compatible](<https://devfeed.tech/tags/postgresql-compatible.md>), [referential-integrity](<https://devfeed.tech/tags/referential-integrity.md>), [relational-databases](<https://devfeed.tech/tags/relational-databases.md>)

### AI overview

AWS Aurora DSQL has added foreign key constraints, including CASCADE and SET NULL actions, addressing an adoption blocker for some users. It checks referential integrity using transaction snapshots and commit-time conflict detection without locking tables. Concurrent conflicts can cause serialization errors, so applications should retry failed transactions; AWS also advises keeping frequently referenced key columns stable.

### Source excerpt

AWS recently announced that Aurora DSQL now supports foreign key constraints, allowing applications to enforce referential integrity directly in the database, including CASCADE, SET NULL, and other referential actions. The addition addresses a long-standing gap that users had explicitly called out as an adoption blocker. By Renato Losio

## This Month in AWS Observability: August - September 2026

DevFeed: [This Month in AWS Observability: August - September 2026](<https://devfeed.tech/articles/this-month-in-aws-observability-august-september-2026-59847.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/mt/this-month-in-aws-observability-august-september-2026/>)

Author: Dot Ho

Published: 2026-09-25T13:36:05Z

Content type: article

Language: en

Sources: [AWS Cloud Operations Blog](<https://devfeed.tech/sources/aws-cloud-operations-blog.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [Amazon CloudWatch](<https://devfeed.tech/topics/amazon-cloudwatch.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>), [agent observability](<https://devfeed.tech/topics/agent-observability.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>)

Tags: [agent-observability](<https://devfeed.tech/tags/agent-observability.md>), [ai](<https://devfeed.tech/tags/ai.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [announcements](<https://devfeed.tech/tags/announcements.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-cloudtrail](<https://devfeed.tech/tags/aws-cloudtrail.md>), [azure](<https://devfeed.tech/tags/azure.md>), [database](<https://devfeed.tech/tags/database.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [evaluation](<https://devfeed.tech/tags/evaluation.md>), [langgraph](<https://devfeed.tech/tags/langgraph.md>), [logs](<https://devfeed.tech/tags/logs.md>), [management-governance](<https://devfeed.tech/tags/management-governance.md>), [management-tools](<https://devfeed.tech/tags/management-tools.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [monitoring-and-observability](<https://devfeed.tech/tags/monitoring-and-observability.md>), [observability](<https://devfeed.tech/tags/observability.md>), [telemetry](<https://devfeed.tech/tags/telemetry.md>)

### AI overview

A roundup of August and September 2026 updates to AWS observability products, led by the general availability of Amazon CloudWatch Omni. The article covers cross-cloud telemetry, AI-assisted investigations, database observability for PostgreSQL and Aurora DSQL, expanded log collection, and broader OpenTelemetry-based telemetry.

### Source excerpt

Introduction August and September brought the general availability of Amazon CloudWatch Omni, an AI-first, app-centric observability experience that brings together telemetry across AWS accounts, Regions, and Azure workloads in a single space. Alarms gained warm-up periods and wall clock evaluation windows, cutting the noise that comes from startup gaps and rolling-window edge cases. Database observability [...]

## Building async Python applications with Tortoise ORM and Amazon Aurora DSQL

DevFeed: [Building async Python applications with Tortoise ORM and Amazon Aurora DSQL](<https://devfeed.tech/articles/building-async-python-applications-with-tortoise-orm-and-amazon-aurora-dsql-4695.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/building-async-python-applications-with-tortoise-orm-and-amazon-aurora-dsql/>)

Author: Lasita Bhattacharya

Published: 2026-09-09T15:27:43Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [AWS IAM](<https://devfeed.tech/topics/aws-iam.md>), [Database](<https://devfeed.tech/topics/database.md>), [CRUD](<https://devfeed.tech/topics/crud.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [database](<https://devfeed.tech/tags/database.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [iam](<https://devfeed.tech/tags/iam.md>), [orm](<https://devfeed.tech/tags/orm.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [rideshare](<https://devfeed.tech/tags/rideshare.md>), [serverless](<https://devfeed.tech/tags/serverless.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

A tutorial for building a high-concurrency asynchronous Python rideshare application with Tortoise ORM and Amazon Aurora DSQL. It covers UUID-based models, IAM-authenticated asyncpg connections, OCC retry handling, and asynchronous CRUD operations.

### Source excerpt

Build a high-concurrency async Python rideshare application with Tortoise ORM and Amazon Aurora DSQL. This post walks through the key adaptations: UUID primary keys, IAM-authenticated asyncpg connections with a connection-pool patch, individual DDL execution, and optimistic concurrency control (OCC) retry logic.

## Amazon Aurora DSQL observability concepts and usage with Amazon CloudWatch

DevFeed: [Amazon Aurora DSQL observability concepts and usage with Amazon CloudWatch](<https://devfeed.tech/articles/amazon-aurora-dsql-observability-concepts-and-usage-with-amazon-cloudwatch-4694.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/amazon-aurora-dsql-observability-concepts-and-usage-with-amazon-cloudwatch/>)

Author: James Morle

Published: 2026-08-17T23:37:48Z

Content type: article

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-cloudwatch](<https://devfeed.tech/tags/amazon-cloudwatch.md>), [cost](<https://devfeed.tech/tags/cost.md>), [dash](<https://devfeed.tech/tags/dash.md>), [database](<https://devfeed.tech/tags/database.md>), [diagnostics](<https://devfeed.tech/tags/diagnostics.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [insights](<https://devfeed.tech/tags/insights.md>), [intermediate-200](<https://devfeed.tech/tags/intermediate-200.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [observability](<https://devfeed.tech/tags/observability.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

This article explains Amazon Aurora DSQL's time-based observability model and its link to performance and DPU-based cost. It introduces DASH session sampling and using Amazon CloudWatch Database Insights, PromQL, and system diagnostics to identify bottlenecks.

### Source excerpt

Amazon Aurora DSQL offers time-based observability through Amazon CloudWatch Database Insights. Learn how the DSQL observability model, DASH, Database Insights, PromQL, and the system diagnostics AI skill help you find performance bottlenecks and connect session time directly to cost.

## On building scalable control planes

DevFeed: [On building scalable control planes](<https://devfeed.tech/articles/on-building-scalable-control-planes-12436.md>)

Original publisher: [Read original article](<https://www.allthingsdistributed.com/2026/08/on-building-scalable-control-planes.html>)

Author: werner@allthingsdistributed.com (Dr. Werner Vogels)

Published: 2026-08-04T14:00:00Z

Content type: article

Language: en

Sources: [All Things Distributed](<https://devfeed.tech/sources/all-things-distributed.md>)

Topics: [distributed-systems](<https://devfeed.tech/topics/distributed-systems.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>)

Tags: [aws](<https://devfeed.tech/tags/aws.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [distributed-systems](<https://devfeed.tech/tags/distributed-systems.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [posts](<https://devfeed.tech/tags/posts.md>), [servers](<https://devfeed.tech/tags/servers.md>), [ssh](<https://devfeed.tech/tags/ssh.md>)

### AI overview

This article explores the engineering of scalable control planes through Zak van der Merwe's experience building them at AWS, first for EC2 and later for DSQL. It explains how control planes record intended state and reconcile it with actual state, bringing together difficult distributed-systems problems and influencing whether services can survive growth.

### Source excerpt

Zak van der Merwe has spent his entire career at AWS building control planes. First for EC2 and now for DSQL. On the surface, the control plane looks quite boring: it records what should exist and reconciles that with what actually does. Nobody leaves school dreaming of building one, but Zak will be the first to tell you that if you like solving hard problems in distributed systems, there are few better places to be. It's where many of those hard problems converge, and where the decisions you make determine whether a service survives its own growth.

## Generating Referentially Consistent Synthetic Test Data for PostgreSQL in .NET Application Modernization

DevFeed: [Generating Referentially Consistent Synthetic Test Data for PostgreSQL in .NET Application Modernization](<https://devfeed.tech/articles/generating-referentially-consistent-synthetic-test-data-for-postgresql-in-net-application-modernization-49974.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/dotnet/generating-referentially-consistent-synthetic-test-data-for-postgresql-in-net-application-modernization/>)

Author: Sayan Ghosh

Published: 2026-07-29T18:46:25Z

Content type: tutorial

Language: en

Sources: [.NET on AWS Blog](<https://devfeed.tech/sources/net-on-aws-blog.md>)

Topics: [AWS Transform](<https://devfeed.tech/topics/aws-transform.md>), [dataset](<https://devfeed.tech/topics/dataset.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [.NET](<https://devfeed.tech/topics/net.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [AI Agent](<https://devfeed.tech/topics/ai-agent.md>), [Amazon Bedrock](<https://devfeed.tech/topics/amazon-bedrock.md>), [Software Testing](<https://devfeed.tech/topics/software-testing.md>), [Strands Agents](<https://devfeed.tech/topics/strands-agents.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-bedrock](<https://devfeed.tech/tags/amazon-bedrock.md>), [aws-transform](<https://devfeed.tech/tags/aws-transform.md>), [database](<https://devfeed.tech/tags/database.md>), [large-language-model](<https://devfeed.tech/tags/large-language-model.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [migration](<https://devfeed.tech/tags/migration.md>), [modernization](<https://devfeed.tech/tags/modernization.md>), [net](<https://devfeed.tech/tags/net.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [postgresql-compatible](<https://devfeed.tech/tags/postgresql-compatible.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [test-data](<https://devfeed.tech/tags/test-data.md>)

### AI overview

This article explains how AWS Transform for SQL Server modernization generates referentially consistent synthetic test data for migrated PostgreSQL schemas in .NET applications. Its agentic workflow derives an execution strategy from the relational schema and validates foreign-key, uniqueness, check, and type constraints.

### Source excerpt

Satyajit Gokhale, Aiswaryaa Venugopalan, Ruchi Agarwal, Nits Jeganathan, Khurram Khawaja, Vijay Mandadi, and Luke Huan contributed to this article. Within the .NET application modernization service of AWS Transform, enterprise customers are also provided an option to migrate the database layer of the application from Microsoft SQL Server to Amazon Aurora PostgreSQL Compatible Edition. Modernizing to [...]

## Aurora DSQL: Scalable, Multi-Region OLTP

DevFeed: [Aurora DSQL: Scalable, Multi-Region OLTP](<https://devfeed.tech/articles/aurora-dsql-scalable-multi-region-oltp-41849.md>)

Original publisher: [Read original article](<https://muratbuffalo.blogspot.com/2026/07/aurora-dsql-scalable-multi-region-oltp.html>)

Author: Murat (noreply@blogger.com)

Published: 2026-07-24T00:15:59Z

Content type: opinion

Language: en

Sources: [Metadata](<https://devfeed.tech/sources/metadata.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Database](<https://devfeed.tech/topics/database.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [Routing (disambiguation)](<https://devfeed.tech/topics/routing.md>), [stateless](<https://devfeed.tech/topics/stateless.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [aws](<https://devfeed.tech/tags/aws.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [concurrency-control](<https://devfeed.tech/tags/concurrency-control.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [distributed-transactions](<https://devfeed.tech/tags/distributed-transactions.md>), [distsql](<https://devfeed.tech/tags/distsql.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [mvcc](<https://devfeed.tech/tags/mvcc.md>), [paper-review](<https://devfeed.tech/tags/paper-review.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [routing](<https://devfeed.tech/tags/routing.md>), [stateless](<https://devfeed.tech/tags/stateless.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

An analysis of Aurora DSQL's architecture, which decomposes a traditional monolithic database into independently scalable services for query processing, storage, conflict resolution, replication, and routing. It also examines synchronized clocks, MVCC, snapshot isolation, and optimistic concurrency control.

### Source excerpt

The Aurora DSQL paper finally dropped. Reading it yesterday was an interesting experience, because I spent two years (2022-23) working with the AWS team that designed and built Aurora DSQL. Since I have been very familiar with the architecture, the paper's overview description of the system didn't excite me much. And if I am being honest, reading the paper also felt a bit dry, most likely because I am not doing the usual extra thinking to explore/understand the ideas in the paper. But taking a step back today, and leaving my subjective experience aside, I will try to elaborate on how the DSQL architecture is actually built on a set of aggressive and opinionated engineering bets. If I had to explain this architecture in a single sentence (just as I used to do for other teams at AWS) it would be this: We took a traditional monolithic database and blew out every single component into an independent, horizontally scalable service. Exploding the Monolith DSQL divides the database into the following specialized services: Query Processors (QP): Stateless virtual machines that run a custom PostgreSQL engine to parse queries and buffer writes locally. Storage Nodes: Sharded nodes that hold the data and use multiversion concurrency control (MVCC) to serve historical data to QP instantly. Adjudicators: The conflict-resolution layer that checks if a transaction handed of to them by QP is safe to commit. Journals: A highly available replication log that durably saves transactions across zones or regions. (Good for short term durability before this reaches the storage nodes. See my MemoryDB review.) Crossbars: The routing layer that reads the updates from the Journals and sends changes to the right Storage Nodes. The Big Architectural Bets in DSQL Design Well, in addition to fully committing to the disaggregation principle, here are the other big bets in DSQL design. The Synchronized Clock Bet: To get reads without coordination, DSQL relies entirely on highly synchronized physica

## Aurora DSQL: Scalable, Multi-Region OLTP

DevFeed: [Aurora DSQL: Scalable, Multi-Region OLTP](<https://devfeed.tech/articles/aurora-dsql-scalable-multi-region-oltp-12599.md>)

Original publisher: [Read original article](<http://brooker.co.za/blog/2026/07/19/dsql-paper.html>)

Author: Marc Brooker

Published: 2026-07-19T00:00:00Z

Content type: article

Language: en

Sources: [Marc Brooker's](<https://devfeed.tech/sources/marc-brooker-s-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Database](<https://devfeed.tech/topics/database.md>), [Distributed Systems & Parallel Computing](<https://devfeed.tech/topics/distributed-systems-parallel-computing.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [scalable-architecture](<https://devfeed.tech/topics/scalable-architecture.md>), [Production Engineering](<https://devfeed.tech/topics/production-engineering.md>), [control-plane](<https://devfeed.tech/topics/control-plane.md>)

Tags: [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [application](<https://devfeed.tech/tags/application.md>), [applications](<https://devfeed.tech/tags/applications.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [architectures](<https://devfeed.tech/tags/architectures.md>), [arxiv](<https://devfeed.tech/tags/arxiv.md>), [aws](<https://devfeed.tech/tags/aws.md>), [blog](<https://devfeed.tech/tags/blog.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [complexity](<https://devfeed.tech/tags/complexity.md>), [control-plane](<https://devfeed.tech/tags/control-plane.md>), [database](<https://devfeed.tech/tags/database.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [durability](<https://devfeed.tech/tags/durability.md>), [dynamodb](<https://devfeed.tech/tags/dynamodb.md>), [fault-tolerance](<https://devfeed.tech/tags/fault-tolerance.md>), [interactive](<https://devfeed.tech/tags/interactive.md>), [multi-region](<https://devfeed.tech/tags/multi-region.md>), [operations](<https://devfeed.tech/tags/operations.md>)

### AI overview

Aurora DSQL's paper describes a disaggregated relational database built to scale while reducing operational complexity, including in multi-region deployments. It separates query processing, transactions, replication, storage, and control-plane concerns across independent services. The excerpt highlights avoiding large caches to ease failovers and read scaling, providing strongly consistent scalable reads to avoid some hot-key and partition problems, and running scans near local SSD at storage. It also describes optimistic concurrency control (OCC), which prevents clients from blocking one another; the author says lock contention and retries in pessimistic databases often contribute to outages and long recovery times. The paper argues that packing workloads can improve utilization by reducing peak-to-average load per machine. Its account presents strong consistency as a practical default in light of advances in time distribution, networks, and datacenter infrastructure. These are the author's claims; the excerpt does not provide full evaluation details.

### Source excerpt

Aurora DSQL: Scalable, Multi-Region OLTP A paper! Our new paper, Aurora DSQL: Scalable, Multi-Region OLTP, is now available on Arxiv. I'm excited about this one: it's a fully end-to-end look at how Aurora DSQL works, from query processing, to transactions, to replication, to the control plane. We've shared most of this content before in other forms, on this blog, on Marc Bowes' Blog, Werner's Blog, in talks, and on the AWS blog. But this version covers all the ground, all in one place. You should read it. Or check out the interactive transaction simulator to get a feel for how it works. Some highlights Our overall goal was to build a relational database system that simplifies the work of application building and operations, freeing builders from worrying about scale, reliability, durability, and even multi-region fault tolerance. A database of first resort, which is simple and easy to adopt at low scale, and grows with the application, without adding complexity. I've written about this argument before (in DSQL: Simplifying Architectures), and it remains the thing that excites me most about the Aurora DSQL product. I believe we've made it much easier (and, in many cases, cheaper) to build and operate resilient, highly available, cloud applications at all scales. That applies to systems built by humans and agents, with the benefits magnified for agentic builders. Agents are great at building, but not (yet?) so great at long-horizon tasks like database operations. A database designed to simplify operations really helps. DSQL's architecture is disaggregated. Multiple independent services, each focused on a small number of well-defined concerns. DSQL isn't the first disaggregated OLTP database. Many, including Aurora and DynamoDB, came before. What's interesting here is how we learned from those systems, and the lessons that came from operating them at scale: avoiding large caches (they make failovers and read scale tricky), offering strongly consistent scalable reads (a

## Why Strong Consistency?

DevFeed: [Why Strong Consistency?](<https://devfeed.tech/articles/why-strong-consistency-12582.md>)

Original publisher: [Read original article](<http://brooker.co.za/blog/2025/11/18/consistency.html>)

Author: Marc Brooker

Published: 2025-11-18T00:00:00Z

Content type: article

Language: en

Sources: [Marc Brooker's](<https://devfeed.tech/sources/marc-brooker-s-blog.md>)

Topics: [consistency](<https://devfeed.tech/topics/consistency.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [Database](<https://devfeed.tech/topics/database.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [Microservices](<https://devfeed.tech/topics/microservices.md>), [control-plane](<https://devfeed.tech/topics/control-plane.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [application](<https://devfeed.tech/tags/application.md>), [architectures](<https://devfeed.tech/tags/architectures.md>), [aws](<https://devfeed.tech/tags/aws.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [control-plane](<https://devfeed.tech/tags/control-plane.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [ec2](<https://devfeed.tech/tags/ec2.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [operations](<https://devfeed.tech/tags/operations.md>), [primary](<https://devfeed.tech/tags/primary.md>), [read-replica](<https://devfeed.tech/tags/read-replica.md>), [read-replicas](<https://devfeed.tech/tags/read-replicas.md>), [replica](<https://devfeed.tech/tags/replica.md>), [replication](<https://devfeed.tech/tags/replication.md>), [scale](<https://devfeed.tech/tags/scale.md>), [service](<https://devfeed.tech/tags/service.md>)

### AI overview

The excerpt argues that eventual consistency in read-replica databases makes ordinary workflows unreliable: a read after a successful write can report missing data, retries can loop or add latency, and reads used to trigger writes may see stale state. Routing such reads to the primary adds application logic and limits read scaling. Aurora DSQL aims to avoid this by making reads strongly consistent while scaling reads across replicas. Each transaction picks a start timestamp; a replica serves data at that time once it has received updates through that timestamp from all subscribed journals, otherwise the read blocks until it catches up. The author acknowledges latency and connectivity trade-offs and says eventual consistency can have a place.

### Source excerpt

Why Strong Consistency? Eventual consistency makes your life harder. When I started at AWS in 2008, we ran the EC2 control plane on a tree of MySQL databases: a primary to handle writes, a secondary to take over from the primary, a handful of read replicas to scale reads, and some extra replicas for doing latency-insensitive reporting stuff. All of thing was linked together with MySQL's statement-based replication. It worked pretty well day to day, but two major areas of pain have stuck with me ever since: operations were costly, and eventual consistency made things weird. Since then, managed databases like Aurora MySQL have made relational database operations orders of magnitude easier. Which is great. But eventual consistency is still a feature of most database architectures that try scale reads. Today, I want to talk about why eventual consistency is a pain, and why we invested heavily in making all reads strongly consistent in Aurora DSQL. Eventual Consistency is a Pain for Customers Consider the following piece of code, running against an API exposed by a database-backed service: id = create_resource(...) get_resource_state(id, ...) In the world of read replicas, the latter statement can do something a little baffling: reply 'id does not exist'. The reason for this is simple: get_resource_state is a read-only call, likely routed to a read replica, and is racing the write from create_resource. If replication wins, this code works as expected. If the client wins, it has to handle to weird sensation of time moving backwards. Application programmers don't really have a principled way to work around this, so they end up writing code like this: id = create_resource(...) while True: try: get_resource_state(id, ...) return except ResourceDoesNotExist: sleep(100) Which fixes the problem. Kinda. Other times, especially if ResourceDoesNotExist can be thrown if id is deleted, it causes an infinite loop. It also creates more work for client and server, adds latency, and req

## DSQL: Simplifying Architectures

DevFeed: [DSQL: Simplifying Architectures](<https://devfeed.tech/articles/dsql-simplifying-architectures-12581.md>)

Original publisher: [Read original article](<http://brooker.co.za/blog/2025/11/02/thinking-dsql.html>)

Author: Marc Brooker

Published: 2025-11-02T00:00:00Z

Content type: article

Language: en

Sources: [Marc Brooker's](<https://devfeed.tech/sources/marc-brooker-s-blog.md>)

Topics: [DSQL](<https://devfeed.tech/topics/dsql.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [consistency](<https://devfeed.tech/topics/consistency.md>), [AWS Lambda](<https://devfeed.tech/topics/aws-lambda.md>)

Tags: [architectures](<https://devfeed.tech/tags/architectures.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [clusters](<https://devfeed.tech/tags/clusters.md>), [complexity](<https://devfeed.tech/tags/complexity.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [cost](<https://devfeed.tech/tags/cost.md>), [cost-management](<https://devfeed.tech/tags/cost-management.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [database](<https://devfeed.tech/tags/database.md>), [dsql](<https://devfeed.tech/tags/dsql.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [engines](<https://devfeed.tech/tags/engines.md>), [failover](<https://devfeed.tech/tags/failover.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [isolation](<https://devfeed.tech/tags/isolation.md>), [memory](<https://devfeed.tech/tags/memory.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [patching](<https://devfeed.tech/tags/patching.md>), [serverless](<https://devfeed.tech/tags/serverless.md>), [storage](<https://devfeed.tech/tags/storage.md>)

### AI overview

Aurora DSQL aims to simplify database-backed systems by handling capacity, patching, sharding, replication, and failover behind one endpoint, with costs tied to database work. It offers strongly consistent snapshot isolation equivalent to PostgreSQL REPEATABLE READ, SQL support over PostgreSQL's wire protocol, and IAM-based authentication; the excerpt describes a simple load balancer, application tier, and regional database architecture that can scale and tolerate failures. Constraints help limit operational complexity: writes are capped at 10 MiB or 3,000 rows per transaction, and transactions at five minutes. DSQL has few configuration knobs and uses leaderless active-active writes, which can surface conflicts at commit and increase latency for some read workloads. It supports async index creation but does not yet offer foreign key constraints, stored procedures, or vector workloads, according to the excerpt.

### Source excerpt

DSQL: Simplifying Architectures Complexity is a choice. While we were designing and building Aurora DSQL, we spent a lot of time thinking about our experience building and running database-backed systems. We saw that building great, fast, cost-effective, highly-available, systems was harder than it needed to be. We wanted to make it easier. Today, I want to discuss some of Aurora DSQL's features, and how I think they come together to make your life, as an application, service, or website developer, easier. We wanted for our customers what we wanted for ourselves: a relational database that allows us to build great systems with simple architectures. Serverless: The most obvious one is serverlessness. With DSQL you don't need to pick hardware, manage clusters, design for failover, think about patching engines or systems, monitor CPU and memory, or any of the many other tasks that come with good cluster management. When you get started with any database, you can basically ignore these things: buying excess CPU and memory at small scale is cheap, and monitoring is easy when you aren't also trying to drive efficiency. But this is a kind of operational debt, which will eventually come due. With DSQL, you can avoid this debt entirely: the system scales memory, CPU, and storage to meet your application's needs, and so you don't need to monitor these things. It keeps the database software and system software up-to-date too. Scale-down: I see a lot of database architectures take on a lot of complexity to reduce cost during nights and weekends: scaling down primaries, removing read replicas, and even removing secondaries. These are smart cost management things with many database products, but you simply don't need them with DSQL. DSQL scales up and down with your application, priced on the amount of work your database is doing, not the scale of your infrastructure. Doing no work? You'll spend no money. Strong consistency and just-right isolation: DSQL offers a single isolation

## How We Migrated Millions of UGC Records to Aurora MySQL

DevFeed: [How We Migrated Millions of UGC Records to Aurora MySQL](<https://devfeed.tech/articles/how-we-migrated-millions-of-ugc-records-to-aurora-mysql-38727.md>)

Original publisher: [Read original article](<https://blog.developer.bazaarvoice.com/2025/08/25/how-we-migrated-millions-of-ugc-records-to-aurora-mysql/>)

Author: Kovi

Published: 2025-08-25T10:42:12Z

Content type: article

Language: en

Sources: [Bazaarvoice](<https://devfeed.tech/sources/bazaarvoice.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [DSQL](<https://devfeed.tech/topics/dsql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Amazon RDS](<https://devfeed.tech/topics/amazon-rds.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [software-architecture](<https://devfeed.tech/topics/software-architecture.md>), [reliability-engineering](<https://devfeed.tech/topics/reliability-engineering.md>), [Resilience](<https://devfeed.tech/topics/resilience.md>)

Tags: [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [amazon-rds](<https://devfeed.tech/tags/amazon-rds.md>), [aws](<https://devfeed.tech/tags/aws.md>), [cost](<https://devfeed.tech/tags/cost.md>), [database](<https://devfeed.tech/tags/database.md>), [devops](<https://devfeed.tech/tags/devops.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-5-7](<https://devfeed.tech/tags/mysql-5-7.md>), [performance](<https://devfeed.tech/tags/performance.md>), [reliability](<https://devfeed.tech/tags/reliability.md>)

### AI overview

Bazaarvoice describes migrating millions of user-generated content records from Amazon RDS for MySQL to Amazon Aurora MySQL. The article explains the operational limits, performance and scaling challenges, and a two-phase modernization that first standardized on MySQL 8.0 before the Aurora migration.

### Source excerpt

Discover how Bazaarvoice migrated millions of UGC records from RDS MySQL to AWS Aurora - at scale and with minimal user impact. Learn about the technical challenges, strategies, and outcomes that enabled this ambitious transformation in reliability, performance, and cost efficiency Bazaarvoice ingests and serves millions of user-generated content (UGC) items--reviews, ratings, questions, answers, and [...]

[Next page](<https://devfeed.tech/topics/dsql.md?cursor=WyIyMDI1LTA4LTI1VDEwOjQyOjEyKzAwOjAwIiwgIjliOTBjNmYxLWVkOTQtNDc4Ni04YjEyLTMyOTQwNjI3Mjk1ZSJd>)