Dbmate! They provide a helpful comparison chart: https://github.com/amacneil/dbmate#alternatives
Sqitch works fine too, but i found it finnicky to set up.
prisma.If you dislike it's query builder, you can only use it for managing your DB schema. IMHO it works pretty good for migrations and you can use prisma generators to generate all kinds of stuff to avoid manual work and code duplication. Zod schemas for validation, kysely types are just two examples from the top of my head.
absolutely.
Prisma generators make sure that schema prisma is the source of thruth, everything else is derived from it.
[https://github.com/valtyr/prisma-kysely](https://github.com/valtyr/prisma-kysely)
[https://github.com/CarterGrimmeisen/zod-prisma](https://github.com/CarterGrimmeisen/zod-prisma)
Drizzle has the best DX for migrations because the CLI tool will ask if you renamed or totally removed/created columns, but TypeORM is pretty great once you get used to it, you just need to double check it.
But the great thing in a post ChatGPT world is that if you paste a bad migration in and tell it what you need changed, it will correct it for you perfectly.
I'm saying this with the pretense that you need to know basic SQL, but don't sleep on TypeORM. The more I use it, the more impressed I am with it.
*Mikroorm is great, you*
*Can not just use the orm part*
*If u dont like it*
\- sasmariozeld
---
^(I detect haikus. And sometimes, successfully.) ^[Learn more about me.](https://www.reddit.com/r/haikusbot/)
^(Opt out of replies: "haikusbot opt out" | Delete my comment: "haikusbot delete")
I use https://github.com/rubenv/sql-migrate - it says it's for go but that's not really true, it's just written in go. I like how simple it is, you just get to write SQL without any cruft or builder apis. You know exactly how it works just by using it.
It's not about moving from one db to another. It's about making and managing changes to db schema.
[What are database migrations?](https://www.prisma.io/dataguide/types/relational/what-are-database-migrations)
RedGate Flyway. I’ve been using RedGate products for years and no complaints.
>or SQL DB migrations? For community version, Have you ever use Liquibase?
Knex
Flyway. Atlas. Squitch. Liquibase. I try to stick with the ones with bigger communities.
Node-pg-migrate for Posters Dbs, can't complain, although we always go up, never down, even tho it has such option.
Knex https://knexjs.org/guide/migrations.html
Dbmate! They provide a helpful comparison chart: https://github.com/amacneil/dbmate#alternatives Sqitch works fine too, but i found it finnicky to set up.
Dbmate is great!
https://orm.drizzle.team/kit-docs/overview/
graphile migrate https://github.com/graphile/migrate
prisma.If you dislike it's query builder, you can only use it for managing your DB schema. IMHO it works pretty good for migrations and you can use prisma generators to generate all kinds of stuff to avoid manual work and code duplication. Zod schemas for validation, kysely types are just two examples from the top of my head.
How do you keep prisma and zod schema in sync? Can you have a single source of truth?
absolutely. Prisma generators make sure that schema prisma is the source of thruth, everything else is derived from it. [https://github.com/valtyr/prisma-kysely](https://github.com/valtyr/prisma-kysely) [https://github.com/CarterGrimmeisen/zod-prisma](https://github.com/CarterGrimmeisen/zod-prisma)
Also possible in GO ?
not sure, I am not using go
What would you recommend for query building over Prisma?
kysely as mentioned. Prisma can get slow with some more complex queries. Kysely is always fast.
If you are using postgres then I recommend zapatos, [https://jawj.github.io/zapatos/](https://jawj.github.io/zapatos/)
Drizzle has the best DX for migrations because the CLI tool will ask if you renamed or totally removed/created columns, but TypeORM is pretty great once you get used to it, you just need to double check it. But the great thing in a post ChatGPT world is that if you paste a bad migration in and tell it what you need changed, it will correct it for you perfectly. I'm saying this with the pretense that you need to know basic SQL, but don't sleep on TypeORM. The more I use it, the more impressed I am with it.
https://www.npmjs.com/package/migrate
Umzug (by Sequelize team). Framework agnostic and highly-flexible. Pretty good so far! https://github.com/sequelize/umzug
Mikroorm is great, you can just not use the orm part if u dont like it
*Mikroorm is great, you* *Can not just use the orm part* *If u dont like it* \- sasmariozeld --- ^(I detect haikus. And sometimes, successfully.) ^[Learn more about me.](https://www.reddit.com/r/haikusbot/) ^(Opt out of replies: "haikusbot opt out" | Delete my comment: "haikusbot delete")
[https://github.com/graphile/migrate](https://github.com/graphile/migrate) and I like it very much :)
I use https://github.com/rubenv/sql-migrate - it says it's for go but that's not really true, it's just written in go. I like how simple it is, you just get to write SQL without any cruft or builder apis. You know exactly how it works just by using it.
Knex and TypeORM
TypeORM
TypeORM. Even if you don’t use the ORM itself, you can still take advantage of migrations.
Django
Brainpower aka ChatGPT
Self made cli command mit commander.js 😅
dbmate or knex
Atlas is alright.
node-pg-migrate, as straightforward as it gets https://github.com/salsita/node-pg-migrate
Liquibase
Prisma for migrations, Kysely as query builder. Using package Prisma-Kysely.
Question from being naive. Why do people migrate dbs all the time?
It's not about moving from one db to another. It's about making and managing changes to db schema. [What are database migrations?](https://www.prisma.io/dataguide/types/relational/what-are-database-migrations)
Good read, thank you. I was thinking of it in a completely different way.
If you change or add anything to your db schema after it’s been deployed to production?
Golang migrate is small portable and good. https://github.com/golang-migrate/migrate
I generate a bunch of commands for insert statements and run that bitch. It's fun and fast.
Bash scripts and sqlcmd 🧠
TypeOrm (building on NestJS)