With the migrations for RDS databases, if I create...
# sstj
jamlen
03/10/2022, 9:21 AMWith the migrations for RDS databases, if I create multiple database, how do the migrations know which database to run them against?
jamlen
03/10/2022, 9:23 AMIs it just that I keep the scripts for each DB separate?
Copy code
new sst.RDS(this, "CustomersDb", {
engine: "postgresql10.14",
defaultDatabaseName: "Customers",
migrations: "scripts/migrations/customers",
})
new sst.RDS(this, "FulfillmentDb", {
engine: "postgresql10.14",
defaultDatabaseName: "Fulfillment",
migrations: "scripts/migrations/fulfillment",
})t
thdxr
03/10/2022, 2:13 PMwe pass in the right DB when executing the script
thdxr
03/10/2022, 2:14 PMeach cluster gets its own lambda function that runs migrations
f
Frank
03/10/2022, 5:19 PM
@jamlen by “multiple database” you mean multiple
RDSj
jamlen
03/10/2022, 5:20 PM@Frank yes, each of our stacks are having their own RDS DB
f
Frank
03/10/2022, 5:22 PM
I see.. b/c each RDS construct can contain multiple databases. Just wanted to clarify it.
Frank
03/10/2022, 5:23 PM
So yeah, if u have multiple RDS constructs, each get their own
migrationsj
jamlen
03/10/2022, 5:32 PM@Frank do the migration files have to be in js format? I'm getting
Copy code
ERROR TypeError: Unknown file extension ".ts" for ~/dev/src/github.com/jamlen/demo/backend/scripts/migrations/customers/00001-init-customers.tsjamlen
03/10/2022, 5:33 PMIts not very clear in the docs
t
thdxr
03/10/2022, 5:47 PMyeah we currently require them to be in js, have ideas for supporting ts but not implemented yet
3 Views