All news with #aurora dsql tag

Aurora DSQL Adds Python, Node.js, and JDBC Connectors

🔐 Aurora DSQL now provides Python, Node.js, and JDBC Connectors that transparently handle IAM token generation for standard PostgreSQL drivers. The connectors integrate with psycopg/psycopg2, node-postgres, Postgres.js, and the PostgreSQL JDBC driver and support common pooling libraries such as HikariCP and built-in pooling in Node.js and Python. By automatically generating IAM tokens via the AWS SDK for each connection, they remove the need for custom token code or manual token provisioning, reducing reliance on static database passwords while preserving existing driver features and workflows.

Amazon Aurora DSQL Adds Integrated Console Query Editor

🔎 Amazon has added an integrated query editor to Aurora DSQL, enabling secure, browser-based SQL access from the AWS Management Console without requiring external client installation or configuration. The editor includes syntax highlighting, auto-completion, and intelligent code assistance, along with schema exploration and result viewing in a single interface. Available in all Regions where Aurora DSQL is offered, this feature shortens time-to-value and simplifies database interactions for developers, analysts, and data engineers.

Aurora DSQL Adds Statement-Level DPU Cost Estimates

🔍 Amazon Aurora DSQL now surfaces statement-level cost estimates directly in query plans, providing developers immediate visibility into resource use per SQL statement. The EXPLAIN ANALYZE VERBOSE output is extended to append per-category (compute, read, write, and multi-Region write) and total estimated Distributed Processing Unit (DPU) usage. This enhancement offers fine-grained, real-time cost insight that complements CloudWatch metrics, enabling faster identification of cost drivers and more effective query tuning. The feature is available in all Regions where Aurora DSQL is supported.

Amazon Aurora DSQL Adds Resource-Based Policies Support

🔒 Amazon Web Services has added resource-based policies to Aurora DSQL, letting administrators define which IAM principals can perform specific IAM actions on Aurora DSQL resources. Policies also support Block Public Access (BPA) controls to restrict access to public or VPC endpoints. The capability is available now in a set of regions and the documentation provides guidance to get started.

Amazon Aurora DSQL Now Available in Frankfurt Region

🚀 Amazon Aurora DSQL is now available in Europe (Frankfurt), expanding AWS’s global footprint for its serverless distributed SQL engine. The managed service provides active-active high availability, multi-Region strong consistency, and automatic, virtually unlimited scaling so teams can build always-on applications without infrastructure management. Aurora DSQL is advertised as offering the fastest distributed SQL reads and writes, and is already available across US, Asia Pacific, and European Regions. Customers can trial it via the AWS Free Tier.

Aurora DSQL Adds FIS Integration for Resilience Testing

🔧 Amazon announces that Aurora DSQL now integrates with AWS Fault Injection Service (FIS) to enable controlled resilience testing for applications that depend on Aurora DSQL. Customers can simulate regional connectivity disruptions and full inaccessibility to validate failover, reconnection, and recovery behaviours across single-Region and multi-Region deployments. Experiment templates can be included in CI pipelines and FIS generates detailed reports that can be stored in Amazon S3 for auditing and compliance. The capability is available in multiple AWS Regions.