Serverless Stack

hey folks, my team is planning to use Aurora Postgresql

Is there any pattern/good practices using SST for schema migration?

if you mean migration in the sense of knex-style migration (building up iterations of DB table changes), I just use knex in my SST project. I have a `db` folder that has migrations &amp; seeds in it

<@U029JQLBTEJ>, that’s exactly what I mean

we're putting together a more advanced sample project that will have this

in there we're using `kysely` and running migrations through `sst.Script`

<@U02PNQHSYQ6> I'll dump some examples here in a bit

<@U02PNQHSYQ6> this is my project structure (SST project).. just the database part:
```├── knex-get-secrets.js
├── knex-util.js
├── knexfile.js
├── migrations
│   ├── 005_create_functions.js
│   ├── 010_create_types.js
│   ├── 020_create_users.js
│   └── ...etc...
└── seeds
    ├── 10_themes.js
    ├── 20_plans.js
    ├── 30_features.js
    └── 40_groups.js```
I’ve got a couple of scripts in package.json
```    "db:migrate": "knex --knexfile db/knexfile.js migrate:latest",
    "db:seed": "knex --knexfile db/knexfile.js seed:run",```
that’s really about it!

I mean, assuming you’re familiar with knex.. all that above should make sense

and if I make changes to the DB, I just do `yarn knex migrate:make whatever` and then `yarn db:migrate`

This is still very rough with little documentation but if you want a preview of our kysely + migrations setup checkout this: <https://github.com/serverless-stack/graphql-stack/tree/main/backend>

We have a migrator functioin in there that youc an invoke from console to run migrations

<https://github.com/serverless-stack/graphql-stack/blob/main/backend/services/migrator/migrator.ts>

<https://github.com/serverless-stack/graphql-stack/blob/main/stacks/Database.ts>