Hey all, In case anyone is interested, I've managed to enable a CLI mode for the Schema Diff on this repo:
https://github.com/steve-chavez/pgadmin4/blob/cli/web/cli.py It basically works by using a Flask test client that interacts with the Schema Diff endpoints. It's a single isolated file, I haven't patched any of the existing modules. For a quickstart, there's also a docker image that can be used like: docker run supabase/pgadmin-schema-diff \ 'postgres://postgres@host/diff_source' \ 'postgres://postgres@host/diff_target' \ > diff.sql ## the stderr output shows the same messages as the Schema Diff GUI: Starting schema diff... Comparision started......0% Comparing FTS Dictionaries ...35% Comparing Functions ...50% Comparing Trigger Functions ...60% Comparing Sequences ...70% Comparing Tables ...80% Comparing Views ...90% Done. On Wed, 10 Mar 2021 at 13:42, Steve Chavez <st...@supabase.io> wrote: > Hey all, > > The Schema Diff tool is amazing, works much better than all the current > OSS alternatives. > > However, it's only possible to use it from the GUI and thus it cannot be > used programmatically, which would be really useful for CI/CD > environments(deployment automation). > > Would you guys be open to make the Schema Diff work through a CLI? > > Best regards, > Steve >
