Ask HN: How can I get clean solution for migrations in Node.js?

3 pointslifeplusplus4 comments

I want simple schema editor, where I can add/change sql schema, preferably simple GUI that generates update/alter/etc commands and it'd generate up/down migrations which then can also be ran then on prod.

View on HN

Have a look at https://prisma.io or https://atlasgo.io

2nd link is very much what I was thinking, I didn't even know how to search for it

Check out Prisma Migrate. It's a schema migrations tool that allows you to declare your schema declaratively using the Prisma schema language and generate SQL migrations for that you can edit: https://www.prisma.io/migrate

it does what I wanted but hate that it's more than that, it's acting like ORM which is I'd like to avoid.

Reply on news.ycombinator.com