sailfork / t3code-github / .repos/ alchemy-effect/ examples/ aws-dsql-drizzle
.repos/alchemy-effect/examples/aws-dsql-drizzle/README.md
Drizzle + Aurora DSQL + Lambda
Deploy
From the repository root:
pnpm install
cd examples/aws-dsql-drizzle
pnpm deploy --profile testing Use a DSQL region such as us-west-2. Deployment needs dsql:DbConnectAdmin and network access to port 5432; these resources incur AWS charges.
Query
aws lambda invoke --region us-west-2 \
--function-name '<functionName>' \
--cli-binary-format raw-in-base64-out \
--payload file://health-event.json response.json
cat response.json Use the printed function name. Signed HTTP CRUD examples.
Schema and connections
Cluster · Deployment-only bootstrap · Non-admin connection and verified TLS
Initial setup creates app.todos and app_user. Later schema changes need versioned, DSQL-compatible migrations.
Live test
ALCHEMY_PROFILE=testing bun test test/integ.test.ts Destroy
pnpm destroy --profile testing
aws dsql get-cluster --region us-west-2 --identifier '<clusterId>' Destroy deletes the database data. Deletion is asynchronous; wait for DELETED or ResourceNotFoundException.