awslabs / green-boost

Build Full Stack Cloud Native Web Apps on AWS Fast
https://awslabs.github.io/green-boost/
Apache License 2.0
71 stars 8 forks source link

Automatic Migrations with drizzle-kit #208

Closed bestickley closed 1 year ago

bestickley commented 1 year ago

Currently in the Aurora PG Serverless template, we use kysely migrations which work fine, but recently drizzle-kit has come out that automatically creates SQL migrations for you. It looks awesome, but we'll need to consider how we can use it in a Lambda environment. Depending upon the file system is challenging but I think it should be doable with a single schema file.

If we successfully integrate this, would it be worth using drizzle-kit-orm? Nothing wrong with kysely, but something to consider.

bestickley commented 1 year ago

Completed in #228