undefined | Better HN

0 pointscanadiantim1mo ago0 comments

What 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...

0 comments

evanelias1mo ago

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.

j / k navigate · click thread line to collapse