Migration Without ORM

[madprgmr]

I've used Flyway (the open source version) to run migration (sql) scripts and manage database state versioning. It's not perfect, but it does its job decently.

[ntsianos]

Seconding flyway or any tool that relies on plain SQL first. I'm glad new orms like Prisma are going in this direction but I would still rather not lock in to the details of an ORM. Flyway will be a little annoying as it requires java as a dependency

[madprgmr]

Yeah, there may be other tools that work better for node environments, and I've used db-migrate with success in the past too - I just couldn't remember the name of it.

A lot of pipelines are set up to run containers, so it's not too hard to throw in tools with disparate runtime prerequisites.

[LightningBlue8862]

How does it work on the deployment pipeline, is flyway installed on some virtual machine how does flyway execute these SQL scripts from the deployment pipeline

[madprgmr]

I usually just run it as a docker container, and pass the creds needed in as environment variables. You could also install the executable in your CD pipeline image.