Chainguard Container for flyway

Flyway is a database migration tool to evolve your database schema easily and reliably across all your instances.

Chainguard Containers are regularly-updated, secure-by-default container images.

Download this Container Image

For those with access, this container image is available on cgr.dev:

docker pull cgr.dev/ORGANIZATION/flyway:latest

Be sure to replace the ORGANIZATION placeholder with the name used for your organization's private repository within the Chainguard Registry.

Compatibility Notes

The Flyway Chainguard Image is meant to serve as a drop-in replacement for the Flyway image from Docker Hub. Like most other Chainguard Images, this image has few-to-zero CVEs and does not run as the root user.

The only difference between the Chainguard Image and the official Flyway image is that the Chainguard Image uses JDK 17 while the official Flyway image uses JDK 21.

Getting Started

To begin, start the Flyway container with a command like the following:

docker run --rm cgr.dev/ORGANIZATION/flyway

This will return the Flyway Command-line's usage instructions.

Next, configure Flyway by creating a file named flyway.conf:

mkdir -p /tmp/flyway
cat <<EOF > /tmp/flyway/flyway.conf
flyway.url=jdbc:sqlite:/flyway/db/test_db.sqlite3
flyway.user=sa
EOF

This example assumes that you have a SQLite database named test_db.sqlite3 in the /tmp/flyway/db directory.

Following that, create the first migration file:

cat <<EOF > /tmp/flyway/sql/V1__Create_person_table.sql
create table PERSON (
    ID int not null,
    NAME varchar(100) not null
);
EOF

Finally, run the migration:

docker run --rm -v "/tmp/flyway/db:/flyway/db" -v "/tmp/flyway/sql:/flyway/sql" -v "/tmp/flyway/sql:/flyway/conf" cgr.dev/ORGANIZATION/flyway migrate

If everything worked as expected, you will receive the following output:

Database: jdbc:sqlite:/flyway/db/test_db.sqlite3 (SQLite 3.34)
Schema history table "main"."flyway_schema_history" does not exist yet
Successfully validated 1 migration (execution time 00:00.009s)
Creating Schema History table "main"."flyway_schema_history" ...
Current version of schema "main": << Empty Schema >>
Migrating schema "main" to version "1 - Create person table"
Successfully applied 1 migration to schema "main", now at version v1 (execution time 00:00.034s)

Documentation and Resources

• (Blog) Quickstart - Docker

What are Chainguard Containers?

Chainguard Containers are minimal container images that are secure by default.

In many cases, the Chainguard Containers tagged as :latest contain only an open-source application and its runtime dependencies. These minimal container images typically do not contain a shell or package manager. Chainguard Containers are built with Wolfi, our Linux undistro designed to produce container images that meet the requirements of a more secure software supply chain.

The main features of Chainguard Containers include:

• Minimal design, without unnecessary software bloat
• Daily builds to ensure container images are up-to-date with available security patches
• High quality build-time SBOMs attesting to the provenance of all artifacts within the image
• Verifiable signatures provided by Sigstore
• Reproducible builds with Cosign and apko (read more about reproducibility)

For cases where you need container images with shells and package managers to build or debug, most Chainguard Containers come paired with a -dev variant.

Although the -dev container image variants have similar security features as their more minimal versions, they feature additional software that is typically not necessary in production environments. We recommend using multi-stage builds to leverage the -dev variants, copying application artifacts into a final minimal container that offers a reduced attack surface that won’t allow package installations or logins.

Learn More

To better understand how to work with Chainguard Containers, please visit Chainguard Academy and Chainguard Courses.

In addition to Containers, Chainguard offers VMs and Libraries. Contact Chainguard to access additional products.

Trademarks

This software listing is packaged by Chainguard. The trademarks set forth in this offering are owned by their respective companies, and use of them does not imply any affiliation, sponsorship, or endorsement by such companies.