Connect to AWS RDS with aws-sdk client

[sthuber90]

I see that the migration requires a PostgreSQL client to handle the database calls. Would it be possible to extend the library to use the aws ask client to connect to an Aurora Serverless V1 database? This would make configuring a VPC, or opening the database up to the public obsolete and greatly reduce complexity in using node-pg-migrate to manage migrations on Aurora Serverless clusters on AWS.

[seyfer]

@sthuber90 I think you are describing a very specific use-case.
You need to use AWS CDK to manage infrastructure and deploy AWS RDS Aurora instance with CDK.
Then you can add to CDK outputs the newly deployed RDS URL and port. Or you can find them in AWS console.
Use these to set DATABASE_URL env variable as in this package readme.

[sthuber90]

I got it working with node-pg-migrate. Just would want to be able to do it without having to use a VPC ;)

[pkit]

@sthuber90 you can use https://github.com/marcgreenstock/data-api-suite
It has a pretty good migration tool.