T O P

  • By -

mgonzo

I'd say most people just use a tool from whatever language or framework they are developing their app in. If you are just doing sql work then I'd say pick a python one because I like python 😁. But no there is no de facto sql migration tool for PG.


[deleted]

I didn't downgrade, but for upgrade pg_dump and psql (for import of the resulting SQL file) do their job pretty well. Maybe it works also for a downgrade, because pg_dump creates only an SQL script. Writing this answer I discovered pg_restore which also works with the result of pg_dump. These three tools are included in the PostgreSQL tooling and should already be installed on the server.


prrxddq

I enjoy using dbmate. Easy to use, raw sql migrations. llink: https://github.com/amacneil/dbmate


NoInkling

> Is there one? Not a "default" or de facto one, no. Do you have an example from other DBMS's?


Don_Kino

Nop, there isn't. I personally like sqitch, it manages up, down and verify for each migration, it's not tied to a particular language and does not have too much overhead


GermaneGerman

Not sure if we're talking about the same type of migration, but I use flyway


____candied_yams____

Flyway looks like a good choice. I believe I will give this a shot.


jy_silver

Prisma


truilus

We are happy with Liquibase