What's Changed

• feat(enum): add PostgreSQL enum type diffing by @jasdeepkhalsa in #173

Full Changelog: v3.0.0-rc.1...v3.0.0-rc.2

What's Changed

• Adding Postgres 14-18 & SQLite Support by @jasdeepkhalsa in #141
• Expanded Migrations (Flyway, Liquibase XML/YAML, Laravel) & Adds Native DBDiff Migration CLI & Supabase Support by @jasdeepkhalsa in #142
• Multi-Platform Binary Distributions (Windows, Mac, Linux, npm) & Box PHAR Builds by @jasdeepkhalsa in #143
• Fix Windows binary builds and decouple npm publish from all-binaries-succeed requirement by @Copilot in #144
• Fix binary build failures: darwin-x64 runner retired, darwin-arm64 API rate limit, Windows missing libs by @jasdeepkhalsa in #145
• Fix Windows binary builds and publish job artifact download failure by @jasdeepkhalsa in #146
• Fixing Windows Builds - Adding Debug by @jasdeepkhalsa in #147
• fix: add zlib to SPC_WINDOWS_LIBS; drop win32-arm64 target by @jasdeepkhalsa in #148
• Fix Windows release pipeline and add PHAR fallback for all platformsFeature/fix win release 4 by @jasdeepkhalsa in #149
• fix: add win32-x64 to PHAR_FALLBACK_PKGS alongside win32-arm64 by @jasdeepkhalsa in #150
• fix: win32-x64 build, PHP 8.2 deprecation, and release workflow tag checkout by @jasdeepkhalsa in #151
• fix(release): separate source checkout from tooling checkout by @jasdeepkhalsa in #152
• Feature/fix release 8 by @jasdeepkhalsa in #153
• Supabase / DSN URL support, PHP 8.2+ fixes, CI hardening, and binary build tooling by @jasdeepkhalsa in #154
• feat(supabase): Supabase first-class support by @jasdeepkhalsa in #156
• feat: Streaming sorted-merge diff for PostgreSQL, SQLite sha3 hash, MySQL CHECKSUM pre-scan by @jasdeepkhalsa in #158
• fix: Key Bug Fixes from DBDiff issues and community PRs by @jasdeepkhalsa in #157
• feat: Views, Triggers & Routines diff support — full DB object coverage across MySQL, PostgreSQL, SQLite by @jasdeepkhalsa in #160
• chore(github): enabled windows binaries, add triage bot, issue templates, and bulk issue/PR tooling by @jasdeepkhalsa in #161
• feat(release): add pre-release support (alpha/beta/rc) by @jasdeepkhalsa in #162
• fix(ci): batch-close workflow — support file & CLI dispatch without committing batch files by @jasdeepkhalsa in #163
• feat(release): Multiple Registry Releases (GitHub Packages, npm), Release dry-run Workflow, tag support in batch-close by @jasdeepkhalsa in #166
• feat(filtering): fine-grained table, column, row, and scope filtering by @jasdeepkhalsa in #169
• Fixing .github/workflows/release.yml for Windows SPC by @jasdeepkhalsa in #171
• fix(sql): MySQL DROP FOREIGN KEY, FK ordering, default/index normalization by @jasdeepkhalsa in #170
• fix(release): use correct micro.sfx filename on Windows by @jasdeepkhalsa in #172

Full Changelog: v2.0.0...v3.0.0-rc.1

DBDiff v2.0.0 — What's New

✅ Tested Matrix (all passing)

🏗️ Local Dev Environment

• Added Docker (docker-compose) setup with MySQL & PHP for consistent local dev
• New ./start.sh and ./stop.sh scripts to spin the environment up/down
• Watch mode added to the test runner for instant feedback while coding

🔌 Modern PHP & Dependency Support

• Now supports PHP 7.4, 8.3, 8.4, and 8.5 (fixes deprecated dynamic properties & static call warnings)
• Updated illuminate/* packages (Database, View, Container) to support v8–v11
• Updated phpunit/phpunit to support v10 & v11
• Updated diff/diff to v3.0 for PHP 8.4+ compatibility

🧪 Testing

• Added 10+ new integration tests covering schema and data diff scenarios
• Added Record Mode to auto-generate/update test fixtures
• Deterministic sorting of SQL dumps to prevent flaky cross-platform tests
• Full MySQL 8.0, 8.4, 9.3, and 9.6 compatibility confirmed
• New --fast and --testdox flags added to the test runner

🔒 Security & CI/CD

• GitHub Actions workflows added for automated PHAR builds and releases
• Added SECURITY.md policy
• Integrated SonarCloud for automated code quality & security scanning
• Improved Dockerfile security

📚 Docs

• New DOCKER.md guide for local dev setup
• README.md updated to reflect modern workflow and install steps

⚠️ Breaking Change

• Drops support for versions earlier than PHP 7.3 (v1.x era infrastructure)
• PHP 7.3 may be supported but it is not tested. PHP 7.4 is still supported; PHP 8.x and MySQL 8/9 are now fully supported
• This is a major version bump (v1 → v2) — although the config largely remains backwards compatible with v1.0.0

What's Changed

• v2.0.0 Preparation by @jasdeepkhalsa in #136
• Adding support for PHP 8.5 and MySQL 9.6 by @jasdeepkhalsa in #139

Full Changelog: v1.0.0...v2.0.0

PHAR

Requires PHP ≥ 7.3.

chmod +x dbdiff.phar
sudo mv dbdiff.phar /usr/local/bin/dbdiff
dbdiff --version

To build a PHAR locally from source, see Building a PHAR.

Build locally

See DOCKER.md for cross-version testing, Podman usage, and start.sh flags.

As we have some exciting upgrades coming for DBDiff in the near future, it made sense to call a v1.0.0 release here mostly for reference purposes and to ensure backwards compatibility is maintained as we release more features, bugfixes and updates.

You can also now create your own PHAR builds which was a long requested feature kindly contributed by @plashenkov.

This release is compatible with PHP 7.x.

It has been previously used with PHP 5.x, but this is no longer a supported branch.

Please stay tuned!