db-migrate / db-migrate-base

Base driver for db-migrate
Other
7 stars 16 forks source link

Support for Aurora Data API backend #30

Open hawkaa opened 3 years ago

hawkaa commented 3 years ago

Hi there,

I just wanted to ask what you guys think about supporting the Data API for Aurora Serverless?

Basically, this allows you to run queries synchronously via HTTP, using AWS IAM and AWS Secrets Manager for authentication and authorization. Using the Data API lets you avoid thinking about VPCs, subnets, and SSH tunnels, and is especially powerful when accessing the database from a Lambda.

As far as I know, there would have to be a new driver created to support this, which used the AWS SDK to run the queries. Do you have any thoughts whether this is possible?

Seems like some ORMs in the Node ecosystem have connectors already, including sequelize and TypeORM.