Spike: Investigate Database Transactions

[pixiwyn]

Description

Within Postgres/DynamoDB, given a large update, can we convert this to transactions (Kysely?).

Depends on entities being moved from DynamoDB and Opensearch.

Acceptance Criteria

Where we implement transactions first, what needs to be done first, and how would it look upon implementation?

Pain points

• Large updates will fail, only part of the data is updated, should either all pass or fail.

Notes

• DynamoDB transactions are limited (~100 transactions?)
• https://kysely.dev/docs/examples/transactions/simple-transaction

[pixiwyn]

It seems like it's a little early to point this based on discussion. We've explored dynamodb transaction which are limited and we're still not quite sure how far we'll take postgres.

@akuny adding hold (dx/ox) label for this ticket.