alt Hacker NewsWhat do you think of the approach that pg_roll takes?
Seems like the top contenders, at least for Postgres, are:
sqldef: https://news.ycombinator.com/item?id=46845239
pgschema: https://github.com/pgschema/pgschema
pg_roll: https://github.com/xataio/pgroll
atlas: https://github.com/ariga/atlas
grate (minimal SQL-based migrations): https://grate-devs.github.io/grate/
pg-schema-diff: https://github.com/stripe/pg-schema-diff
results: https://github.com/djrobstep/results
https://david.rothlis.net/declarative-schema-migration-for-s...
pgroll is definitely interesting; it overlaps between both schema management tools and online schema change tools. At scale, I would want to have a better understanding on the performance implications of putting views in front of hot tables. I don't like its use of YAML. iiuc, it is an imperative migration tool, not a declarative tool.
Grate is also imperative, not declarative.
That last link (david.rothlis.net) is about a declarative tool for sqlite, not Postgres.