Amazon Aurora DSQL adds support for identity columns and sequence objects

Amazon Aurora DSQL

Now supports identity columns and sequence objects, enabling developers to generate auto-incrementing, integer-based IDs directly in the database using familiar SQL patterns. This simplifies migrations of existing PostgreSQL applications and supports development of new workloads that rely on database-managed integer identifiers.

Developers can create compact, human-readable IDs, such as order numbers, account IDs, or operational references without custom ID generation logic in application code or middleware.

Aurora DSQL support for identity columns and sequence objects is available in all Regions where Aurora DSQL is available. To learn more, see the Aurora DSQL documentation on sequences and identity columns.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.