Amazon Aurora DSQL introduces support for the PostgreSQL JSON data type with optional compression. With JSON data type support, you can now use code and tools that depend on PostgreSQL’s JSON type with Aurora DSQL without modification, making it easier to store semi-structured data alongside relational data.
You can use the JSON data type when creating or modifying tables to store semi-structured data such as API payloads, configuration objects, or event logs. With PostgreSQL compression enabled by default, larger JSON payloads are stored more efficiently, helping reduce storage costs.
For details on the supported data types, see the Aurora DSQL documentation. Get started with Aurora DSQL for free with the AWS Free Tier. For information about Regional availability, see the AWS Region table. To learn more about Aurora DSQL, visit the webpage.
Categories: marketing:marchitecture/databases
Source: Amazon Web Services
Latest Posts
- Amazon FSx for OpenZFS now supports on-demand data replication across AWS opt-in Regions
- AWS Management Console Private Access now works without internet connectivity
- (Updated) Viva Engage: Email updates for frontline users without an active Exchange mailbox [MC1309743]
- (Updated) Microsoft Purview: Data Security Investigations – analyze files tied to endpoint DLP alerts [MC1258000]
![(Updated) Outlook: Share Word, Excel and PowerPoint local files via the new Outlook for Windows [MC1245222]](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-skitterphoto-390089-150x150.webp "(Updated) Outlook: Share Word, Excel and PowerPoint local files via the new Outlook for Windows [MC1245222] 6")
