PermitEx runs integration tests against PostgreSQL because the migrations use PostgreSQL partial indexes for global and context-specific assignments.

Local PostgreSQL Container

Start PostgreSQL:

docker compose up -d postgres

Run the test suite:

DATABASE_URL=postgres://postgres:postgres@localhost:55432/permit_ex_test mix test

Stop the container:

docker compose down

GitHub Actions

The repository includes a GitHub Actions workflow with a PostgreSQL service container. It runs:

mix format --check-formatted
mix compile --warnings-as-errors
mix test
MIX_ENV=dev mix docs
mix hex.build

This gives the SDK a real database verification path without requiring a runtime dependency on a testcontainers library.