DynamoDB Storage Adapter

[aaguiarz]

Add a storage adapter for AWS DynamoDB

[careduct]

For solutions that span multiple AWS regions and operate in an active-active mode, using Aurora PostgreSQL comes with a limitation: it supports multi-region setups, but only one region can contain the writer node at any given time. This means write requests to an OpenFGA node in any region must be rerouted to the region with the writer node, with all that means. In contrast, adopting DynamoDB Global Tables removes this limitation, allowing for a smoother multi-region operation. Furthermore, managing databases is generally easier with DynamoDB than with Aurora, even on the Serverless v2. These advantages make DynamoDB's feature crucial for such multi-region setups.