Ventston
Pgroll vs ariga/Atlas
Thanks for the answer, I asked the same question to the Atlas team to get their point of view:
Personally I haven’t tried pgroll, so can’t comment on it. By looking at the main points it seems like a tool focused on online schema changes for Postgres. Atlas is a database schema as code tool which works with many more databases, includes adapter to most popular orms, has a solution for detecting dangerous migrations in CI, has robust terraform and k8s integration as well as a mature control plane in the cloudthe two tools don't seem quite comparable in their approach to database migration. I think it's great to have several schemas available at the same time with pgroll, facilitating testing and compatibility of applications in version N and N+1. I think it's great to have a tool that's compatible with ORMs and can perform diffs on database schemas with Atlas. I also really like your documentation, with detailed examples and clear diagrams. Thanks for all your hard work!
3 replies