tern VS liquibase

We have a repo with migrations written in SQL, and we use tern[1] to apply them.

[1]: https://github.com/jackc/tern

If you are using postgres and pgx you may want to use tern.

Recently i started using turn its more fun (IMPO) compared to others tool available https://github.com/jackc/tern

We use https://github.com/jackc/tern library (from the author of the pgx driver). We run migrations in k8s init containers and we do not do rollbacks (only up). Advantages over other popular solutions are:

I’ve been happy with https://github.com/jackc/tern .

I use tern for migrations. It’s from the same Author as pgx so everything in that ecosystem plays well.

Now my next issue is I'm trying to install tern using the "go versions 1.17 and higher" instructions in the docs here https://github.com/jackc/tern

I use https://github.com/jackc/tern + .env files which interpolate with its config for various environments.

Tern is a great language and framework agnostic solution for SQL migrations https://github.com/jackc/tern

While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase

Have you looked at liquibase?

For those in search of a open source solution with commercial support have a look at https://www.liquibase.org/

I haven't used it for a number of years but it sounds like something like liquibase (https://www.liquibase.org/) might be what you're looking for.

Liquibase

We use https://github.com/liquibase/liquibase, as most of Dev are used to and comfortable with it.

Highly recommend you use either Liquibase or Flyway for schema management, and Testcontainers pg to run a transitive database for your tests.

I haven't used this so I'm not sure it does exactly what you're looking for but I had a DBA recommend it to me as a possible tool to start using as we overhaul our pipelines. https://www.liquibase.org/